APPS.PAY_FI_ARCHIVE_TEL dependencies on PER_ALL_ASSIGNMENTS_F

Line 652: ,per_all_assignments_f as1

648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
651: ,pay_action_interlocks pai
652: ,per_all_assignments_f as1
653: ,hr_soft_coding_keyflex hsck
654: , per_all_people_f pap
655: WHERE ppa.payroll_action_id = p_payroll_action_id
656: AND appa.effective_date BETWEEN l_canonical_start_date

Line 703: per_all_assignments_f as1

699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
702: pay_action_interlocks pai,
703: per_all_assignments_f as1
704: , per_all_people_f pap
705: WHERE ppa.payroll_action_id = p_payroll_action_id
706: AND appa.effective_date BETWEEN l_canonical_start_date
707: AND l_canonical_end_date

Line 1068: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1064:
1065:
1066: -- Temp needed Variables
1067: l_person_id per_all_people_f.person_id%TYPE;
1068: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1069:
1070:
1071: l_EIT_Reported_or_not per_people_extra_info.PEI_INFORMATION5%TYPE;
1072: l_EIT_Insert_or_Update per_people_extra_info.PEI_INFORMATION6%TYPE;

Line 1136: per_all_assignments_f paa,

1132: pap.PER_INFORMATION24,
1133: pac.assignment_id
1134: FROM
1135: pay_assignment_actions pac,
1136: per_all_assignments_f paa,
1137: per_all_people_f pap
1138: WHERE pac.assignment_action_id = p_asg_act_id
1139: AND paa.assignment_id = pac.assignment_id
1140: AND paa.person_id = pap.person_id

Line 1151: FROM PER_ALL_ASSIGNMENTS_F paa

1147: -- Cursor to pick up segment2
1148: cursor csr_get_Segment2
1149: is
1150: SELECT scl.segment2,scl.segment8
1151: FROM PER_ALL_ASSIGNMENTS_F paa
1152: ,HR_SOFT_CODING_KEYFLEX scl
1153: ,pay_assignment_actions pasa
1154: WHERE pasa.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1155: AND pasa.ASSIGNMENT_ID = paa.ASSIGNMENT_ID