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

Line 75: pay_action_information pai

71: pai.action_information4, --STARTER
72: pai.action_information5, --STARTER
73: pai.action_information20 -- Number of Periods Covered
74: FROM pay_assignment_actions paa,
75: pay_action_information pai
76: WHERE paa.payroll_action_id = p_pactid
77: AND paa.assignment_action_id = pai.action_context_id
78: AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'
79: AND pai.action_context_type = 'AAP';

Line 102: pay_action_information pai

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

Line 239: pay_action_information pai

235: IS
236: SELECT DISTINCT paa.assignment_id
237: FROM pay_assignment_actions paa,
238: pay_payroll_actions ppa,
239: pay_action_information pai
240: WHERE paa.payroll_action_id = ppa.payroll_action_id
241: AND ppa.payroll_action_id = p_pactid --1688760
242: AND paa.assignment_action_id = pai.action_context_id;
243:

Line 249: pay_action_information pai

245: IS
246: SELECT DISTINCT paa.assignment_id
247: FROM pay_assignment_actions paa,
248: pay_payroll_actions ppa,
249: pay_action_information pai
250: WHERE paa.payroll_action_id = ppa.payroll_action_id
251: AND ppa.payroll_action_id = p_pactid --1688760
252: AND paa.assignment_action_id = pai.action_context_id
253: and paa.assignment_action_id = p_asgactid;

Line 264: from pay_assignment_Actions paa, pay_action_information pai

260:
261: cursor csr_fetch_agg(p_asg_id number)
262: is
263: select pai.ACTION_INFORMATION10
264: from pay_assignment_Actions paa, pay_action_information pai
265: where paa.payroll_action_id = p_pactid and paa.assignment_id = p_asg_id
266: and pai.action_context_id = paa.assignment_Action_id
267: and pai.ACTION_INFORMATION_CATEGORY = 'GB RTI EMPLOYEE DETAILS';
268: