problem with pay element

[islamic_boy600]

I add a pay element to the payroll , when i try to return the employee who take this element it take a long time with no result and this is the script

Code: Select all

SELECT PAA.FULL_NAME
FROM   PAY_ASSIGNMENT_ACTIONS_V PAA, PAY_RUN_RESULTS_V PRR 
WHERE  PAA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND    PAA.Period_name = (select period_name from PER_TIME_PERIODS_V where payroll_id = 62 and 
       sysdate between start_date and end_date)

[eng_ahmad_2007]

Dear,

I still did not understand your question!
Do you mean the query is slow? or the query is not written correctly?

Also, what are you trying to achieve at the first place?

Regards,

Ahmad Ghanem

[islamic_boy600]

Dear ahmed,

as you know in the saudi oraganziation there are many pay elements,
my oraganization add new element, they request areport that show the employees who take this element.

as i am new in developing in apps i make this script,the syntax is correct but take more than 20 minute iin executing with no result.

so can you advice me how to make this .

Regards

Mohamed Salah

Do you remember me?

[eng_ahmad_2007]

Dear Mohamed,

Tell me your requirement in details. If your requirement is to fetch the employee who recieved payment of a certain element payment within the current Payroll --> then, this query needs some modifications.

By the way, Do you know me? (No offense but I guess I do not regognize your name).

Best Regards,
Ahmad Ghanem

[islamic_boy600]

[quote]Dear Mohamed,

Tell me your requirement in details. If your requirement is to fetch the employee who recieved payment of a certain element payment within the current Payroll --> then, this query needs some modifications.

By the way, Do you know me? (No offense but I guess I do not regognize your name).

Best Regards,
Ahmad Ghanem


<i><div align="right">Originally posted by eng_ahmad_2007

[islamic_boy600]

any solution!!

[islamic_boy600]

i want to make aquery to use it in areport that display the following information:

ID Name Grade payment Deduction Amount

i use the following query but the RESULT_VALUE and the INPUT_VALUE_ID is the problem in this query becuase they are rows not column so the details of the person is displayed in more than one row

Code: Select all

Select paaf.PERSON_ID, papf.full_name, paaf.GRADE_ID,prrv.RESULT_VALUE,prrv.INPUT_VALUE_ID from per_grades pg,pay_element_entries_f peef,pay_run_result_values prrv,pay_run_results prr,per_all_assignments_f paaf,pay_element_types_f petf,per_all_people_f papf ,pay_payroll_actions ppa,pay_assignment_actions paa where prr.element_type_id = petf.element_type_id and paaf.GRADE_ID = pg.grade_id   and prrv.RUN_RESULT_ID = prr.RUN_RESULT_ID   and prr.element_entry_id = peef.element_entry_id   and peef.assignment_id = paaf.assignment_id   and papf.person_id = paaf.person_id   and petf.element_name =:elementname   and ppa.payroll_id =:payrollid   and paa.assignment_action_id = prr.assignment_action_id   and paa.payroll_action_id = ppa.payroll_action_id   and to_char(ppa.effective_date,'MON-YYYY') = to_char(trunc(sysdate),'MON-YYYY')   and sysdate between paaf.effective_start_date and paaf.effective_end_date   and sysdate between peef.effective_start_date and peef.effective_end_date   and sysdate between papf.effective_start_date and papf.effective_end_date