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_NO_ABSENCE dependencies on PAY_RUN_RESULTS

Line 123: , pay_run_results prr

119: CURSOR CSR_RUN_RESULT_FETCH (p_input_name varchar2, stdate date, enddate date) IS
120: SELECT result_value
121: FROM pay_element_types_f pet
122: , pay_element_entries_f pee
123: , pay_run_results prr
124: , pay_run_result_values prrv
125: , pay_input_values_f piv
126: WHERE pet.element_type_id = pee.element_type_id
127: AND pet.element_type_id = prr.element_type_id

Line 8005: , pay_run_results RR

8001: SELECT
8002: count(TARGET.result_value )
8003: FROM pay_run_result_values TARGET
8004: , pay_balance_feeds_f FEED
8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT
8008: , pay_payroll_actions PACT
8009: , pay_payroll_actions BACT

Line 8029: from pay_run_results RR1

8025: and RR.source_id = l_source_id)
8026: or (RR.source_type in ('R','V')
8027: and exists
8028: (select null
8029: from pay_run_results RR1
8030: where RR1.source_id = l_source_id
8031: and RR1.run_result_id = RR.source_id
8032: and RR1.source_type in ( 'E','I'))))
8033: and PACT.time_period_id = BACT.time_period_id;