[Home] [Help]
96: pai.action_information26, --PENSIONER
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'
106:
107: cursor csr_get_all_actions is
108: SELECT paa.assignment_id,
109: paa.assignment_action_id
110: FROM pay_assignment_actions paa
111: WHERE paa.payroll_action_id = p_pactid;
112:
113: CURSOR csr_archive_asgact_details
114: IS
123: pai.action_information26, --PENSIONER
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
260: pai.action_information11, --PENSIONER
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'
270:
271: cursor csr_get_all_actions is
272: SELECT paa.assignment_id,
273: paa.assignment_action_id
274: FROM pay_assignment_actions paa
275: WHERE paa.payroll_action_id = p_pactid;
276:
277: CURSOR csr_archive_asgact_details
278: IS
286: pai.action_information11, --PENSIONER
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
396:
397: CURSOR csr_asgs_processed
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
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:
496:
497: CURSOR csr_asgs_processed
498: IS
499: SELECT DISTINCT paa.assignment_id
500: FROM pay_assignment_actions paa,
501: pay_payroll_actions ppa
502: WHERE paa.payroll_action_id = ppa.payroll_action_id
503: AND ppa.payroll_action_id = p_pactid; --1688760
504:
505: cursor is_prev_flag(p_asg_id number)
506: is
507: select 'Y' from dual where exists(select *
508: from pay_payroll_actions prev,
509: pay_assignment_actions paa
510: where paa.assignment_id = p_asg_id
511: and paa.payroll_action_id = prev.payroll_action_id
512: and prev.payroll_action_id <> p_pactid
513: and prev.ACTION_STATUS='C'
559: pai.action_information9,
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