APPS.PAY_FI_ARCHIVE_TEL dependencies on PER_PEOPLE_EXTRA_INFO

Line 1071: l_EIT_Reported_or_not per_people_extra_info.PEI_INFORMATION5%TYPE;

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;
1073: l_EIT_Last_reported per_people_extra_info.PEI_INFORMATION4%TYPE;
1074: l_current_value varchar2(240);
1075:

Line 1072: l_EIT_Insert_or_Update per_people_extra_info.PEI_INFORMATION6%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;
1073: l_EIT_Last_reported per_people_extra_info.PEI_INFORMATION4%TYPE;
1074: l_current_value varchar2(240);
1075:
1076: l_Sal_subject_pension_MTD NUMBER := 0;

Line 1073: l_EIT_Last_reported per_people_extra_info.PEI_INFORMATION4%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;
1073: l_EIT_Last_reported per_people_extra_info.PEI_INFORMATION4%TYPE;
1074: l_current_value varchar2(240);
1075:
1076: l_Sal_subject_pension_MTD NUMBER := 0;
1077: l_bik_subject_pension_MTD NUMBER := 0;

Line 1184: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )

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,
1188: person_id,

Line 1198: from per_people_extra_info

1194: pei_information4,
1195: pei_information5,
1196: pei_information6,
1197: pei_information7
1198: from per_people_extra_info
1199: where information_type='FI_PENSION'
1200: AND PEI_INFORMATION_CATEGORY='FI_PENSION'
1201: AND PEI_INFORMATION3=CSR_V_COLUMN_NAME
1202: AND PERSON_ID = CSR_V_PERSON_ID;

Line 1221: from per_people_extra_info

1217: pei_information4,
1218: pei_information5,
1219: pei_information6,
1220: pei_information7
1221: from per_people_extra_info
1222: where information_type='FI_PENSION'
1223: AND PEI_INFORMATION_CATEGORY='FI_PENSION'
1224: AND PERSON_ID = CSR_V_PERSON_ID;
1225: