APPS.PER_NL_FDR_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 1203: pay_action_information_api.create_action_information

1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));
1200: utl_file.fclose(l_file);
1201:
1202:
1203: pay_action_information_api.create_action_information
1204: ( p_action_information_id => l_action_info_id
1205: ,p_action_context_id => p_assignment_action_id
1206: ,p_action_context_type => 'AAP'
1207: ,p_object_version_number => l_ovn

Line 1265: from pay_action_information pai,

1261:
1262: select pai.action_information_id act_id,
1263: pai.object_version_number ovn
1264:
1265: from pay_action_information pai,
1266: pay_assignment_actions paa
1267:
1268: where paa.payroll_action_id = p_actid
1269: and pai.action_context_id = paa.assignment_action_id

Line 1278: from pay_action_information pai,

1274:
1275: select distinct pai.action_information4 org_name,
1276: pai.action_information5 tax_reg_num
1277:
1278: from pay_action_information pai,
1279: pay_assignment_actions paa
1280:
1281: where paa.payroll_action_id = p_actid
1282: and pai.action_context_id = paa.assignment_action_id

Line 1294: from pay_action_information pai,

1290: pai.action_information3 sofi_number,
1291: pai.action_information6 hire_date,
1292: pai.action_information7 date_of_birth
1293:
1294: from pay_action_information pai,
1295: pay_assignment_actions paa
1296:
1297: where paa.payroll_action_id = p_actid
1298: and pai.action_context_id = paa.assignment_action_id

Line 1464: --Deleting the data from pay_action_information table

1460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1461:
1462: END LOOP;
1463:
1464: --Deleting the data from pay_action_information table
1465:
1466: FOR v_csr_get_action_information in csr_get_action_information
1467: LOOP
1468:

Line 1469: pay_action_information_api.delete_action_information (p_action_information_id => v_csr_get_action_information.act_id

1465:
1466: FOR v_csr_get_action_information in csr_get_action_information
1467: LOOP
1468:
1469: pay_action_information_api.delete_action_information (p_action_information_id => v_csr_get_action_information.act_id
1470: ,p_object_version_number => v_csr_get_action_information.ovn);
1471:
1472: END LOOP;
1473: