APPS.PAY_GB_ROLLBACK dependencies on PAY_ASSIGNMENT_ACTIONS

Line 74: FROM pay_assignment_actions paa,

70: pai.action_information26, --PENSIONER
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'

Line 84: FROM pay_assignment_actions paa

80:
81: cursor csr_get_all_actions is
82: SELECT paa.assignment_id,
83: paa.assignment_action_id
84: FROM pay_assignment_actions paa
85: WHERE paa.payroll_action_id = p_pactid;
86:
87: CURSOR csr_archive_asgact_details
88: IS

Line 101: FROM pay_assignment_actions paa,

97: pai.action_information26, --PENSIONER
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

Line 237: FROM pay_assignment_actions paa,

233:
234: CURSOR csr_asgs_processed
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

Line 247: FROM pay_assignment_actions paa,

243:
244: CURSOR csr_asgs_asgact_processed
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

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:

Line 380: FROM pay_assignment_actions paa,

376:
377: CURSOR csr_asgs_processed
378: IS
379: SELECT DISTINCT paa.assignment_id
380: FROM pay_assignment_actions paa,
381: pay_payroll_actions ppa
382: WHERE paa.payroll_action_id = ppa.payroll_action_id
383: AND ppa.payroll_action_id = p_pactid; --1688760
384:

Line 388: FROM pay_assignment_actions paa,

384:
385: CURSOR csr_asgs_asgact_processed
386: IS
387: SELECT DISTINCT paa.assignment_id
388: FROM pay_assignment_actions paa,
389: pay_payroll_actions ppa
390: WHERE paa.payroll_action_id = ppa.payroll_action_id
391: AND ppa.payroll_action_id = p_pactid
392: and paa.assignment_action_id = p_asgactid ;

Line 398: pay_assignment_actions paa

394: cursor is_prev_flag(p_asg_id number)
395: is
396: select 'Y' from dual where exists(select *
397: from pay_payroll_actions prev,
398: pay_assignment_actions paa
399: where paa.assignment_id = p_asg_id
400: and paa.payroll_action_id = prev.payroll_action_id
401: and prev.payroll_action_id <> p_pactid
402: and prev.ACTION_STATUS='C'