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_EOY_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 91: ,pay_assignment_actions paa

87: AND action_information2 = p_assess_year
88: AND action_information3 = p_gre_org_id
89: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
90: FROM pay_action_information pai
91: ,pay_assignment_actions paa
92: ,per_assignments_f asg
93: WHERE pai.action_information_category = 'IN_EOY_PERSON'
94: AND pai.action_context_type = 'AAP'
95: AND pai.assignment_id = asg.assignment_id

Line 164: ,pay_assignment_actions paa

160: AND action_information2 = p_assess_year
161: AND action_information3 = p_gre_org_id
162: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
163: FROM pay_action_information pai
164: ,pay_assignment_actions paa
165: ,per_assignments_f asg
166: WHERE pai.action_information_category = 'IN_EOY_PERSON'
167: AND pai.action_context_type = 'AAP'
168: AND pai.assignment_id = asg.assignment_id

Line 315: ,pay_assignment_actions paa

311: CURSOR csr_get_max_cont_id IS
312: SELECT MAX(pai.action_context_id) action_cont_id
313: ,source_id sour_id
314: FROM pay_action_information pai
315: ,pay_assignment_actions paa
316: ,per_assignments_f asg
317: WHERE pai.action_information_category = 'IN_EOY_PERSON'
318: AND pai.assignment_id = asg.assignment_id
319: AND paa.assignment_id = asg.assignment_id