APPS.PAY_FI_ARCHIVE_LTFA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 166: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

162: l_le_name hr_organization_units.name%TYPE ;
163: l_lu_name hr_organization_units.name%TYPE ;
164: l_business_id hr_organization_information.org_information1%TYPE ;
165: l_y_number hr_organization_information.org_information1%TYPE ;
166: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
167: l_counter number := 0;
168:
169:
170: /* Cursors */

Line 604: ,pay_assignment_actions act

600: act1.assignment_action_id prepaid_action_id
601: FROM pay_payroll_actions ppa
602: ,pay_payroll_actions appa
603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1
606: ,pay_action_interlocks pai
607: ,per_all_assignments_f as1
608: ,hr_soft_coding_keyflex hsck

Line 605: ,pay_assignment_actions act1

601: FROM pay_payroll_actions ppa
602: ,pay_payroll_actions appa
603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1
606: ,pay_action_interlocks pai
607: ,per_all_assignments_f as1
608: ,hr_soft_coding_keyflex hsck
609: , per_all_people_f pap

Line 655: pay_assignment_actions act,

651: act1.assignment_action_id prepaid_action_id
652: FROM pay_payroll_actions ppa,
653: pay_payroll_actions appa,
654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,
657: pay_action_interlocks pai,
658: per_all_assignments_f as1
659: , per_all_people_f pap

Line 656: pay_assignment_actions act1,

652: FROM pay_payroll_actions ppa,
653: pay_payroll_actions appa,
654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,
657: pay_action_interlocks pai,
658: per_all_assignments_f as1
659: , per_all_people_f pap
660: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 772: SELECT pay_assignment_actions_s.NEXTVAL

768: ,l_canonical_end_date)
769: LOOP
770: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 4');
771: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
772: SELECT pay_assignment_actions_s.NEXTVAL
773: INTO l_actid
774: FROM dual;
775: --
776: g_index_assact := g_index_assact + 1;

Line 807: SELECT pay_assignment_actions_s.NEXTVAL

803: ,l_canonical_end_date)
804: LOOP
805: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 6');
806: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
807: SELECT pay_assignment_actions_s.NEXTVAL
808: INTO l_actid
809: FROM dual;
810: --
811: g_index_assact := g_index_assact + 1;

Line 869: pay_assignment_actions pac,

865: /* Cursor to retrieve Person Details */
866: CURSOR csr_get_person_details(p_asg_act_id NUMBER) IS
867: SELECT pap.first_name, pap.last_name, pap.pre_name_adjunct, pap.national_identifier , pap.person_id , pac.assignment_id
868: FROM
869: pay_assignment_actions pac,
870: per_all_assignments assign,
871: per_all_people pap
872: WHERE pac.assignment_action_id = p_asg_act_id
873: AND assign.assignment_id = pac.assignment_id

Line 1117: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1113: l_emp_count NUMBER ;
1114: l_emp_sal NUMBER ;
1115: l_pension NUMBER ;
1116: l_emp_pension NUMBER ;
1117: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1118: l_action_info_id NUMBER;
1119: l_ovn NUMBER;
1120: l_business_group_id NUMBER;
1121: l_month VARCHAR2(2);