APPS.PER_PTU_DFF_MIG dependencies on PER_PERSON_TYPE_USAGES_F

Line 448: RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE

444: -- defined for basic EMP Attribute in the mapping form.
445: --
446: FUNCTION RETRIVE_MAPPING(p_mig_rec PER_ALL_PEOPLE_F%ROWTYPE,
447: p_person_rec_context varchar2)
448: RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE
449: IS
450: --
451: TYPE ATTR_TABLE_TYPE IS TABLE OF PER_PTU_DFF_MAPPING_LINES%ROWTYPE
452: INDEX BY BINARY_INTEGER;

Line 461: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%ROWTYPE ;

457: INDEX BY BINARY_INTEGER;
458: --
459: l_per_data_table PER_DATA_TABLE_TYPE;
460: --
461: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%ROWTYPE ;
462: --
463: BEGIN
464: --
465: -- Populate the mapping table.

Line 1138: TYPE PTU_RECORD_CSR_TYPE IS REF CURSOR RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE;

1134: PROCEDURE UPDATE_PTU (P_CONTEXT IN VARCHAR2, P_MIG_TAB IN MIG_TAB_TYPE) IS
1135: --
1136: -- cursor variable type.
1137: --
1138: TYPE PTU_RECORD_CSR_TYPE IS REF CURSOR RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE;
1139: --
1140: -- cursor variable declaration.
1141: --
1142: csrv_ptu_rec PTU_RECORD_CSR_TYPE;

Line 1169: ptu_rec PER_PERSON_TYPE_USAGES_F%rowtype;

1165: --
1166: -- record types.
1167: --
1168: p_mig_rec PER_ALL_PEOPLE_F%rowtype; -- same as table type MIG_TAB_TYPE
1169: ptu_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1170: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1171: mig_tab_new MIG_TAB_TYPE;
1172: --
1173: -- Cursors.

Line 1170: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%rowtype;

1166: -- record types.
1167: --
1168: p_mig_rec PER_ALL_PEOPLE_F%rowtype; -- same as table type MIG_TAB_TYPE
1169: ptu_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1170: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1171: mig_tab_new MIG_TAB_TYPE;
1172: --
1173: -- Cursors.
1174: --

Line 1178: FROM PER_PERSON_TYPE_USAGES_F

1174: --
1175: CURSOR csr_future_records_exists(p_person_type_usage_id number,
1176: p_effective_date date) IS
1177: SELECT 'Y'
1178: FROM PER_PERSON_TYPE_USAGES_F
1179: WHERE person_type_usage_id = p_person_type_usage_id
1180: AND effective_start_date > p_effective_date;
1181: --
1182: -- User defined exceptions.

Line 1233: FROM PER_PERSON_TYPE_USAGES_F PPTU

1229: -- Open the cursor variable.
1230: --
1231: OPEN csrv_ptu_rec FOR
1232: SELECT *
1233: FROM PER_PERSON_TYPE_USAGES_F PPTU
1234: WHERE PPTU.PERSON_ID = l_person_id
1235: AND (PPTU.EFFECTIVE_END_DATE >= l_esd
1236: AND PPTU.EFFECTIVE_START_DATE <= l_eed)
1237: AND EXISTS (SELECT 1

Line 1254: FROM PER_PERSON_TYPE_USAGES_F PPTU

1250: -- Open the cursor variable.
1251: --
1252: OPEN csrv_ptu_rec FOR
1253: SELECT *
1254: FROM PER_PERSON_TYPE_USAGES_F PPTU
1255: WHERE PPTU.PERSON_ID = l_person_id
1256: AND (PPTU.EFFECTIVE_END_DATE >= l_esd
1257: AND PPTU.EFFECTIVE_START_DATE <= l_eed)
1258: AND EXISTS(SELECT 1

Line 1275: FROM PER_PERSON_TYPE_USAGES_F PPTU

1271: -- Open the cursor variable.
1272: --
1273: OPEN csrv_ptu_rec FOR
1274: SELECT *
1275: FROM PER_PERSON_TYPE_USAGES_F PPTU
1276: WHERE PPTU.PERSON_ID = l_person_id
1277: AND (PPTU.EFFECTIVE_END_DATE >= l_esd
1278: AND PPTU.EFFECTIVE_START_DATE <= l_eed)
1279: AND EXISTS(SELECT 1

Line 1382: FROM PER_PERSON_TYPE_USAGES_F

1378: -- As the object version number is changed, get the new.
1379: --
1380: SELECT object_version_number
1381: INTO l_object_version_number
1382: FROM PER_PERSON_TYPE_USAGES_F
1383: WHERE person_type_usage_id = ptu_rec.person_type_usage_id
1384: AND effective_start_date = ptu_rec.effective_start_date
1385: AND effective_end_date = p_mig_rec.effective_end_date;
1386: --

Line 1458: FROM PER_PERSON_TYPE_USAGES_F

1454: -- As the object version number is changed, get the new.
1455: --
1456: SELECT object_version_number
1457: INTO l_object_version_number
1458: FROM PER_PERSON_TYPE_USAGES_F
1459: WHERE person_type_usage_id = ptu_rec.person_type_usage_id
1460: AND effective_start_date = p_mig_rec.effective_start_date
1461: AND effective_end_date = p_mig_rec.effective_end_date;
1462: --