APPS.PER_NL_FDR_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 851: SELECT pay_assignment_actions_s.NEXTVAL

847: FOR v_csr_get_asg_person in csr_get_asg_person(l_person_id, p_start_person_id, p_end_person_id, p_payroll_action_id)
848:
849: LOOP
850:
851: SELECT pay_assignment_actions_s.NEXTVAL
852: INTO l_asg_act_id
853: FROM dual;
854:
855: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_person.assignment_id, p_payroll_action_id,p_chunk,NULL);

Line 871: SELECT pay_assignment_actions_s.NEXTVAL

867: LOOP
868:
869: --hr_utility.set_location('Selecting assignment '||to_char(v_csr_get_asg_org.assignment_id),55);
870:
871: SELECT pay_assignment_actions_s.NEXTVAL
872: INTO l_asg_act_id
873: FROM dual;
874:
875: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_org.assignment_id, p_payroll_action_id,p_chunk,NULL);

Line 893: SELECT pay_assignment_actions_s.NEXTVAL

889: LOOP
890:
891: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' selected before inserting', 62);
892:
893: SELECT pay_assignment_actions_s.NEXTVAL
894: INTO l_asg_act_id
895: FROM dual;
896:
897: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_hier.assignment_id, p_payroll_action_id,p_chunk,NULL);

Line 930: from pay_assignment_actions paa,

926: select hou.organization_id org_id,
927: hou.name org_name,
928: hoi.org_information4 tax_reg
929:
930: from pay_assignment_actions paa,
931: per_all_assignments_f pas,
932: per_assignment_status_types past,
933: hr_organization_units hou,
934: hr_organization_information hoi,

Line 955: from pay_assignment_actions paa,

951: select hou.organization_id org_id,
952: hou.name org_name,
953: hoi.org_information1 tax_reg
954:
955: from pay_assignment_actions paa,
956: per_all_assignments_f pas,
957: per_assignment_status_types past,
958: hr_organization_units hou,
959: hr_organization_information hoi

Line 989: pay_assignment_actions paa,

985:
986: from per_all_people_f pap,
987: per_all_assignments_f pas,
988: per_assignment_status_types past,
989: pay_assignment_actions paa,
990: per_periods_of_service ppos
991:
992: where paa.assignment_action_id = p_assignment_action_id
993: and pas.assignment_id = paa.assignment_id

Line 1059: pay_assignment_actions paa

1055:
1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')
1057: INTO l_report_date
1058: FROM pay_payroll_actions ppa,
1059: pay_assignment_actions paa
1060: WHERE paa.payroll_action_id = ppa.payroll_action_id
1061: AND paa.assignment_action_id = p_assignment_action_id;
1062:
1063: SELECT ppa.legislative_parameters

Line 1066: pay_assignment_actions paa

1062:
1063: SELECT ppa.legislative_parameters
1064: INTO l_parameter_string
1065: FROM pay_payroll_actions ppa,
1066: pay_assignment_actions paa
1067: WHERE paa.payroll_action_id = ppa.payroll_action_id
1068: AND paa.assignment_action_id = p_assignment_action_id;
1069:
1070:

Line 1079: pay_assignment_actions paa

1075:
1076: select TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'ORG_STRUCT_ID'))
1077: INTO l_org_struct_id
1078: FROM pay_payroll_actions ppa,
1079: pay_assignment_actions paa
1080: WHERE paa.payroll_action_id = ppa.payroll_action_id
1081: AND paa.assignment_action_id = p_assignment_action_id;
1082:
1083:

Line 1266: pay_assignment_actions paa

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
1270: and pai.action_information_category = 'NL FDR EMPLOYEE DETAILS';

Line 1279: pay_assignment_actions paa

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
1283: and pai.action_information_category = 'NL FDR EMPLOYEE DETAILS';

Line 1295: pay_assignment_actions paa

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
1299: and pai.action_information_category = 'NL FDR EMPLOYEE DETAILS'

Line 1476: delete from pay_assignment_actions

1472: END LOOP;
1473:
1474: --Deleting assignment actions that have been created - for bug 5446716
1475:
1476: delete from pay_assignment_actions
1477: where payroll_action_id = p_actid;
1478:
1479:
1480: END archive_deinit_code;