APPS.PER_NL_FDR_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

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);