APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PAY_ACTION_INFORMATION

Line 123: pay_action_information_api.create_action_information (

119: OPEN csr_legal_representative_info(to_number(c_rec.person_id),l_end_date);
120: FETCH csr_legal_representative_info INTO l_legal_representative_info;
121: CLOSE csr_legal_representative_info;
122: --Archiving Employee Data
123: pay_action_information_api.create_action_information (
124: p_action_information_id => l_action_info_id
125: , p_action_context_id => p_actid
126: , p_action_context_type => 'PA'
127: , p_object_version_number => l_ovn

Line 189: ,pay_action_information pai

185: AND hoi.organization_id = decode(c_legal_employer,NULL,hoi.organization_id,c_legal_employer)
186: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
187: FROM pay_payroll_actions appa
188: ,pay_assignment_actions act
189: ,pay_action_information pai
190: WHERE act.assignment_id = asl.assignment_id
191: AND act.payroll_action_id = appa.payroll_action_id
192: AND appa.report_category = 'ARCHIVE'
193: AND appa.action_status = 'C'

Line 232: ,pay_action_information pai

228: AND c_end_date between asl.effective_start_date and asl.effective_end_date
229: AND NOT EXISTS (SELECT NULL
230: FROM pay_payroll_actions appa
231: ,pay_assignment_actions act
232: ,pay_action_information pai
233: WHERE act.assignment_id = asl.assignment_id
234: AND act.payroll_action_id = appa.payroll_action_id
235: AND appa.report_category = 'ARCHIVE'
236: AND appa.action_status = 'C'

Line 365: pay_action_information_api.create_action_information (

361: l_found := csr_person_addr%found;
362: CLOSE csr_person_addr;
363: IF l_found THEN
364: -- Archiving Employee Address Information
365: pay_action_information_api.create_action_information (
366: p_action_information_id => l_action_info_id
367: , p_action_context_id => p_assactid
368: , p_action_context_type => 'AAP'
369: , p_object_version_number => l_ovn

Line 419: pay_action_information_api.create_action_information (

415: CLOSE csr_employer_addr;
416:
417: IF l_found THEN
418: -- Archiving Legal Employer Address Information
419: pay_action_information_api.create_action_information (
420: p_action_information_id => l_action_info_id
421: , p_action_context_id => p_actid
422: , p_action_context_type => 'PA'
423: , p_object_version_number => l_ovn

Line 690: pay_action_information_api.create_action_information (

686: l_found := csr_get_ss_id%found;
687: CLOSE csr_get_ss_id;
688:
689: -- Archiving Employee Data
690: pay_action_information_api.create_action_information (
691: p_action_information_id => l_action_info_id
692: , p_action_context_id => p_assactid
693: , p_action_context_type => 'AAP'
694: , p_object_version_number => l_ovn

Line 768: pay_action_information_api.create_action_information (

764: FOR l_cont_base IN csr_Contribution_base(p_assignment_id, p_effective_date)LOOP
765:
766: -- Archiving Element Data
767:
768: pay_action_information_api.create_action_information (
769: p_action_information_id => l_action_info_id
770: , p_action_context_id => p_assactid
771: , p_action_context_type => 'AAP'
772: , p_object_version_number => l_ovn

Line 1047: ,pay_action_information pai1 --Employer rec

1043: ,substr(pai4.action_information12,1,6) epostal_code
1044: ,paa.assignment_action_id
1045: FROM pay_payroll_actions ppa
1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec
1050: ,pay_action_information pai4 --Employee address
1051: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 1048: ,pay_action_information pai2 --Employer Address

1044: ,paa.assignment_action_id
1045: FROM pay_payroll_actions ppa
1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec
1050: ,pay_action_information pai4 --Employee address
1051: WHERE ppa.payroll_action_id = p_payroll_action_id
1052: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1049: ,pay_action_information pai3 --Employee rec

1045: FROM pay_payroll_actions ppa
1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec
1050: ,pay_action_information pai4 --Employee address
1051: WHERE ppa.payroll_action_id = p_payroll_action_id
1052: AND ppa.payroll_action_id = paa.payroll_action_id
1053: AND pai1.action_context_id = ppa.payroll_action_id

Line 1050: ,pay_action_information pai4 --Employee address

1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec
1050: ,pay_action_information pai4 --Employee address
1051: WHERE ppa.payroll_action_id = p_payroll_action_id
1052: AND ppa.payroll_action_id = paa.payroll_action_id
1053: AND pai1.action_context_id = ppa.payroll_action_id
1054: AND pai2.action_context_id (+)= pai1.action_context_id

Line 1081: FROM pay_action_information pai1

1077: ,pai1.action_information8 contribution_days
1078: ,pai1.action_information9 contribution_base
1079: ,pai1.action_information10 ia_id_cont
1080: ,substr(pai1.action_information11,1,20) note
1081: FROM pay_action_information pai1
1082: WHERE pai1.action_context_id = c_assignment_action_id
1083: AND pai1.action_context_type = 'AAP'
1084: AND pai1.action_information_category = 'ES_CC_REP_ELEMENT_INFO'
1085: AND pai1.action_information5 = 'T';

Line 1097: FROM pay_action_information pai1

1093: ,pai1.action_information9 contribution_base
1094: ,pai1.action_information10 ia_id_cont
1095: ,substr(pai1.action_information11,1,20) note
1096: ,pai1.action_information12 last_td_date
1097: FROM pay_action_information pai1
1098: WHERE pai1.action_context_id = c_assignment_action_id
1099: AND pai1.action_context_type = 'AAP'
1100: AND pai1.action_information_category = 'ES_CC_REP_ELEMENT_INFO'
1101: AND pai1.action_information5 = 'S';