APPS.HR_PERSON dependencies on PER_PERSON_TYPE_USAGES_F

Line 2044: FROM per_person_type_usages_f ptu

2040: FROM sys.dual
2041: WHERE EXISTS
2042: (
2043: SELECT 'Future Person Type exists'
2044: FROM per_person_type_usages_f ptu
2045: ,per_person_types ppt
2046: ,per_startup_person_types pst
2047: WHERE ptu.person_type_id = ppt.person_type_id
2048: AND ptu.person_id = p_person_id

Line 2065: from per_person_type_usages_f ptu

2061: into p_test_func
2062: from sys.dual
2063: where exists(
2064: select 'Future Person Type exists'
2065: from per_person_type_usages_f ptu
2066: ,per_person_types ppt
2067: ,per_startup_person_types pst
2068: where ptu.person_type_id = ppt.person_type_id
2069: and ptu.person_id = p_person_id

Line 2140: -- per_person_type_usages_f

2136: --
2137: --
2138: -- Fix for bug 7045968 starts here
2139: -- Modified the select statement to use the person_type_id from
2140: -- per_person_type_usages_f
2141: -- rather than per_people_f
2142:
2143: /*select 'Y'
2144: into p_test_func

Line 2180: from per_person_type_usages_f ptu

2176: into p_test_func
2177: from sys.dual
2178: where exists(
2179: select 'Future Person Type exists'
2180: from per_person_type_usages_f ptu
2181: ,per_person_types ppt
2182: ,per_startup_person_types pst
2183: where ptu.person_type_id = ppt.person_type_id
2184: and ptu.person_id = p_person_id

Line 2249: per_person_type_usages_f ptu

2245: select 'Previous Person type exists'
2246: from per_all_people_f ppf ,
2247: per_person_types ppt ,
2248: per_startup_person_types pst ,
2249: per_person_type_usages_f ptu
2250: where ppf.person_id = p_person_id
2251: and ppf.business_group_id +0= p_business_group_id
2252: and ppf.business_group_id +0= ppt.business_group_id +0
2253: and pst.system_person_type = p_system_person_type