128: --
129: FOR c_rec IN csr_comp_address (l_business_group_id) LOOP
130:
131: --Archiving Employer Address
132: pay_action_information_api.create_action_information (
133: p_action_information_id => l_action_info_id
134: , p_action_context_id => p_actid
135: , p_action_context_type => 'PA'
136: , p_object_version_number => l_ovn
190: AND ppa.effective_date
191: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
192: FROM pay_payroll_actions appa
193: ,pay_assignment_actions act -- Bug Fix 4369797 Changed table order
194: ,pay_action_information pai
195: WHERE appa.action_status = 'C'
196: AND appa.report_type = 'HU_EMP_CERT'
197: AND appa.report_category = 'ARCHIVE'
198: AND appa.report_qualifier = 'HU' -- Bug Fix 4369797
307:
308: IF l_found THEN
309:
310: -- Archiving Employee Address Information
311: pay_action_information_api.create_action_information (
312: p_action_information_id => l_action_info_id
313: , p_action_context_id => p_assactid
314: , p_action_context_type => 'AAP'
315: , p_object_version_number => l_ovn
579:
580: l_total_sickness_holiday := NVL(l_absence_days,0) + to_number(NVL(l_pre_emp_sickness_holiday,'0')) ;
581:
582: -- Archiving Employee Data
583: pay_action_information_api.create_action_information (
584: p_action_information_id => l_action_info_id
585: , p_action_context_id => p_assactid
586: , p_action_context_type => 'AAP'
587: , p_object_version_number => l_ovn