APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_PERSON_PROFILES

Line 103: IF p_owner_table_name = 'HZ_PERSON_PROFILES' THEN

99: -------------------------------------------------------------------------
100: -- First we build tables of Primary Key and Classification Code values --
101: -------------------------------------------------------------------------
102:
103: IF p_owner_table_name = 'HZ_PERSON_PROFILES' THEN
104: l_pk_column_name := 'PERSON_PROFILE_ID';
105: l_object_type := 'PERSON';
106: ELSIF p_owner_table_name = 'HZ_ORGANIZATION_PROFILES' THEN
107: l_pk_column_name := 'ORGANIZATION_PROFILE_ID';

Line 1005: FROM hz_person_profiles p1,

1001: 'N' status
1002: FROM (
1003: SELECT /*+ parallel(p1) parallel(p2) */
1004: max(p2.person_profile_id) old_profile_id, p1.person_profile_id new_profile_id
1005: FROM hz_person_profiles p1,
1006: hz_person_profiles p2
1007: WHERE p1.effective_end_date is null
1008: AND NOT EXISTS (
1009: SELECT null

Line 1006: hz_person_profiles p2

1002: FROM (
1003: SELECT /*+ parallel(p1) parallel(p2) */
1004: max(p2.person_profile_id) old_profile_id, p1.person_profile_id new_profile_id
1005: FROM hz_person_profiles p1,
1006: hz_person_profiles p2
1007: WHERE p1.effective_end_date is null
1008: AND NOT EXISTS (
1009: SELECT null
1010: FROM hz_per_profiles_ext_b ext