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_GB_ROLLBACK_PKG dependencies on PAY_ACTION_INFORMATION

Line 101: pay_action_information pai

97: pai.action_information4, --STARTER
98: pai.action_information5, --STARTER
99: pai.action_information20 -- Number of Periods Covered
100: FROM pay_assignment_actions paa,
101: pay_action_information pai
102: WHERE paa.payroll_action_id = p_pactid
103: AND paa.assignment_action_id = pai.action_context_id
104: AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'
105: AND pai.action_context_type = 'AAP';

Line 128: pay_action_information pai

124: pai.action_information4, --STARTER
125: pai.action_information5, --STARTER
126: pai.action_information20 -- Number of Periods Covered
127: FROM pay_assignment_actions paa,
128: pay_action_information pai
129: WHERE paa.payroll_action_id = p_pactid
130: AND paa.assignment_action_id = p_asgactid --9923676
131: AND paa.assignment_action_id = pai.action_context_id
132: AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'

Line 265: pay_action_information pai

261: pai.action_information12, --PENSIONER
262: pai.action_information3, --STARTER
263: pai.action_information4 --STARTER
264: FROM pay_assignment_actions paa,
265: pay_action_information pai
266: WHERE paa.payroll_action_id = p_pactid
267: AND paa.assignment_action_id = pai.action_context_id
268: AND pai.action_information_category = 'GB_RTI_EYU_ASG_DET'
269: AND pai.action_context_type = 'AAP';

Line 291: pay_action_information pai

287: pai.action_information12, --PENSIONER
288: pai.action_information3, --STARTER
289: pai.action_information4 --STARTER
290: FROM pay_assignment_actions paa,
291: pay_action_information pai
292: WHERE paa.payroll_action_id = p_pactid
293: AND paa.assignment_action_id = p_asgactid --9923676
294: AND paa.assignment_action_id = pai.action_context_id
295: AND pai.action_information_category = 'GB_RTI_EYU_ASG_DET'

Line 402: pay_action_information pai

398: IS
399: SELECT DISTINCT paa.assignment_id
400: FROM pay_assignment_actions paa,
401: pay_payroll_actions ppa,
402: pay_action_information pai
403: WHERE paa.payroll_action_id = ppa.payroll_action_id
404: AND ppa.payroll_action_id = p_pactid --1688760
405: AND paa.assignment_action_id = pai.action_context_id;
406:

Line 416: from pay_assignment_Actions paa, pay_action_information pai

412:
413: cursor csr_fetch_agg(p_asg_id number)
414: is
415: select pai.ACTION_INFORMATION10
416: from pay_assignment_Actions paa, pay_action_information pai
417: where paa.payroll_action_id = p_pactid and paa.assignment_id = p_asg_id
418: and pai.action_context_id = paa.assignment_Action_id
419: and pai.ACTION_INFORMATION_CATEGORY = 'GB RTI EMPLOYEE DETAILS';
420:

Line 564: pay_action_information pai

560: pai.action_information10,
561: pai.action_information11,
562: pai.action_information12
563: from pay_assignment_actions paa,
564: pay_action_information pai
565: where paa.payroll_action_id = p_pactid
566: and paa.assignment_action_id = pai.action_context_id
567: and pai.action_information_category = p_type
568: and pai.action_context_type = 'AAP';