APPS.PAY_FI_ARCHIVE_TEL dependencies on PER_ALL_PEOPLE_F

Line 654: , per_all_people_f pap

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
657: AND l_canonical_end_date
658: AND as1.person_id BETWEEN p_start_person

Line 704: , per_all_people_f pap

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
708: AND as1.person_id BETWEEN p_start_person

Line 1067: l_person_id per_all_people_f.person_id%TYPE;

1063: l_eit_local_unit NUMBER;
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;

Line 1137: per_all_people_f pap

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
1141: AND pap.per_information_category = 'FI'

Line 1183: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,

1179:
1180: -- End of Cursors
1181:
1182: CURSOR CSR_PERSON_EIT (
1183: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,
1184: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )
1185: IS
1186: select PERSON_EXTRA_INFO_ID,
1187: object_version_number,

Line 1207: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE )

1203:
1204: LR_PERSON_EIT CSR_PERSON_EIT%ROWTYPE;
1205:
1206: CURSOR CSR_PERSON_ALL_EIT (
1207: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE )
1208: IS
1209: select PERSON_EXTRA_INFO_ID,
1210: object_version_number,
1211: person_id,

Line 1251: ( CSR_V_PERSON_ID per_all_people_f.person_id%TYPE

1247: lr_Department_code csr_Department_code%ROWTYPE;
1248: --#########################################
1249: -- Cursor to pick up the Absence details
1250: cursor csr_absence_details
1251: ( CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
1252: ,csr_v_start_effective_date DATE
1253: ,csr_v_end_effective_date DATE)
1254: is
1255: