eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 648: ,pay_run_result_values prrv

644: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
645: FROM pay_assignment_actions paa
646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp
650: ,pay_element_types_f pet
651: ,pay_input_values_f piv
652: ,pay_element_entries_f pee

Line 2531: FROM pay_run_result_values prr1

2527: --Find the actual remarks
2528: CURSOR c_remarks(p_run_result_id NUMBER,p_org_iv_id NUMBER,p_rem_iv_id NUMBER,p_org_id NUMBER)
2529: IS
2530: SELECT prr2.result_value
2531: FROM pay_run_result_values prr1
2532: ,pay_run_result_values prr2
2533: WHERE prr1.run_result_id = p_run_result_id
2534: AND prr1.input_value_id = p_org_iv_id
2535: AND prr2.run_result_id = prr1.run_result_id

Line 2532: ,pay_run_result_values prr2

2528: CURSOR c_remarks(p_run_result_id NUMBER,p_org_iv_id NUMBER,p_rem_iv_id NUMBER,p_org_id NUMBER)
2529: IS
2530: SELECT prr2.result_value
2531: FROM pay_run_result_values prr1
2532: ,pay_run_result_values prr2
2533: WHERE prr1.run_result_id = p_run_result_id
2534: AND prr1.input_value_id = p_org_iv_id
2535: AND prr2.run_result_id = prr1.run_result_id
2536: AND prr2.input_value_id = p_rem_iv_id

Line 3493: FROM pay_run_result_values prr1

3489: ,p_rem_iv_id NUMBER
3490: ,p_jur_code VARCHAR2)
3491: IS
3492: SELECT prr2.result_value
3493: FROM pay_run_result_values prr1
3494: ,pay_run_result_values prr2
3495: WHERE prr1.run_result_id = p_run_result_id
3496: AND prr1.input_value_id = p_state_iv_id
3497: AND prr2.run_result_id = prr1.run_result_id

Line 3494: ,pay_run_result_values prr2

3490: ,p_jur_code VARCHAR2)
3491: IS
3492: SELECT prr2.result_value
3493: FROM pay_run_result_values prr1
3494: ,pay_run_result_values prr2
3495: WHERE prr1.run_result_id = p_run_result_id
3496: AND prr1.input_value_id = p_state_iv_id
3497: AND prr2.run_result_id = prr1.run_result_id
3498: AND prr2.input_value_id = p_rem_iv_id