APPS.PAY_NL_CBS_FILE dependencies on PAY_ACTION_INFORMATION

Line 171: from pay_action_information pai

167: ,p_sequence out nocopy number ) return number IS
168:
169: cursor csr_get_max_sequence IS
170: select max(pai.action_information4)
171: from pay_action_information pai
172: where pai.action_information1 = fnd_number.number_to_canonical(p_employer_id)
173: and pai.action_information2 = fnd_number.number_to_canonical(p_si_provider_id)
174: and to_char(pai.effective_date,'YYYY') = to_char(p_reporting_date,'YYYY');
175:

Line 1137: Pay_Action_information_api.create_action_information(

1133: IF g_error_count=0 THEN
1134: -- l_return_value := Pay_nl_cbs_file.Get_er_sequence(l_employer,l_si_provider,l_reporting_date,l_sequence);
1135: -- hr_utility.set_location('Fetched the sequence, employer = '||l_employer||'si provider='||l_si_provider,600);
1136: l_sequence :=1;
1137: Pay_Action_information_api.create_action_information(
1138: P_action_information_id => l_action_info_id
1139: ,p_action_context_id => pactid
1140: ,p_action_context_type => 'PA'
1141: ,p_object_version_number => l_ovn

Line 1329: pay_action_information ee_ats

1325: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)
1326: and not exists
1327: (select 1
1328: from
1329: pay_action_information ee_ats
1330: WHERE ee_ats.action_context_type='AAP'
1331: AND ee_ats.action_information_category = 'NL CBS EMPLOYEE DETAILS'
1332: AND ee_ats.action_information1 =p_employer_id
1333: AND ee_ats.action_information4 =pap.person_id

Line 1611: pay_action_information_api.create_action_information

1607: -- hr_utility.set_location('Inserted new assignment action id',600);
1608: end if;
1609:
1610: -- hr_utility.set_location('Going to archive the ee data',600);
1611: pay_action_information_api.create_action_information
1612: ( p_action_information_id => l_action_info_id
1613: ,p_action_context_id => l_asg_act_id
1614: ,p_action_context_type => 'AAP'
1615: ,p_object_version_number => l_ovn