APPS.PER_PTU_DFF_MIG dependencies on PER_PERSON_TYPES

Line 1030: FROM per_person_types

1026: --
1027: /*
1028: CURSOR csr_is_composite_spt(p_System_Person_Type varchar2) IS
1029: SELECT 'Y'
1030: FROM per_person_types
1031: WHERE system_person_type = p_system_person_type
1032: AND system_person_type not in ('APL','EMP','EX_APL','EX_EMP','OTHER');
1033: --
1034: CURSOR csr_is_composite_ptid(p_Person_Type_ID number) IS

Line 1036: FROM per_person_types

1032: AND system_person_type not in ('APL','EMP','EX_APL','EX_EMP','OTHER');
1033: --
1034: CURSOR csr_is_composite_ptid(p_Person_Type_ID number) IS
1035: SELECT 'Y'
1036: FROM per_person_types
1037: WHERE person_type_id = p_person_type_id
1038: AND system_person_type not in ('APL','EMP','EX_APL','EX_EMP','OTHER');
1039: --
1040: CURSOR csr_is_composite_upt(p_User_Person_Type varchar2) IS

Line 1042: FROM per_person_types

1038: AND system_person_type not in ('APL','EMP','EX_APL','EX_EMP','OTHER');
1039: --
1040: CURSOR csr_is_composite_upt(p_User_Person_Type varchar2) IS
1041: SELECT 'Y'
1042: FROM per_person_types
1043: WHERE user_person_type = p_user_person_type
1044: AND system_person_type not in ('APL','EMP','EX_APL','EX_EMP','OTHER');
1045: */
1046: --

Line 1049: FROM per_person_types

1045: */
1046: --
1047: CURSOR csr_is_composite_spt(p_System_Person_Type varchar2) IS
1048: SELECT 'Y'
1049: FROM per_person_types
1050: WHERE system_person_type = p_system_person_type
1051: AND system_person_type in ('EMP_APL','EX_EMP_APL','APL_EX_APL');
1052: --
1053: CURSOR csr_is_composite_ptid(p_Person_Type_ID number) IS

Line 1055: FROM per_person_types

1051: AND system_person_type in ('EMP_APL','EX_EMP_APL','APL_EX_APL');
1052: --
1053: CURSOR csr_is_composite_ptid(p_Person_Type_ID number) IS
1054: SELECT 'Y'
1055: FROM per_person_types
1056: WHERE person_type_id = p_person_type_id
1057: AND system_person_type in ('EMP_APL','EX_EMP_APL','APL_EX_APL');
1058: --
1059: CURSOR csr_is_composite_upt(p_User_Person_Type varchar2) IS

Line 1061: FROM per_person_types

1057: AND system_person_type in ('EMP_APL','EX_EMP_APL','APL_EX_APL');
1058: --
1059: CURSOR csr_is_composite_upt(p_User_Person_Type varchar2) IS
1060: SELECT 'Y'
1061: FROM per_person_types
1062: WHERE user_person_type = p_user_person_type
1063: AND system_person_type in ('EMP_APL','EX_EMP_APL','APL_EX_APL');
1064: --
1065: l_composite varchar2(1);

Line 1238: FROM PER_PERSON_TYPES PPT

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
1238: FROM PER_PERSON_TYPES PPT
1239: WHERE PPT.PERSON_TYPE_ID = PPTU.PERSON_TYPE_ID
1240: AND PPT.BUSINESS_GROUP_ID = l_business_group_id
1241: AND PPT.SYSTEM_PERSON_TYPE = l_system_person_type)
1242: ORDER BY PERSON_TYPE_ID, EFFECTIVE_START_DATE;

Line 1259: FROM PER_PERSON_TYPES PPT

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
1259: FROM PER_PERSON_TYPES PPT
1260: WHERE PPT.PERSON_TYPE_ID = PPTU.PERSON_TYPE_ID
1261: AND PPT.BUSINESS_GROUP_ID = l_business_group_id
1262: AND PPT.PERSON_TYPE_ID = l_person_type_id)
1263: ORDER BY PERSON_TYPE_ID, EFFECTIVE_START_DATE;

Line 1280: FROM PER_PERSON_TYPES PPT

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
1280: FROM PER_PERSON_TYPES PPT
1281: WHERE PPT.PERSON_TYPE_ID = PPTU.PERSON_TYPE_ID
1282: AND PPT.BUSINESS_GROUP_ID = l_business_group_id
1283: AND PPT.USER_PERSON_TYPE = l_user_person_type)
1284: ORDER BY PERSON_TYPE_ID, EFFECTIVE_START_DATE;