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 1011: FROM hz_person_profiles p1,

1007: 'N' status
1008: FROM (
1009: SELECT /*+ parallel(p1) parallel(p2) */
1010: max(p2.person_profile_id) old_profile_id, p1.person_profile_id new_profile_id
1011: FROM hz_person_profiles p1,
1012: hz_person_profiles p2
1013: WHERE p1.effective_end_date is null
1014: AND p1.actual_content_source IN ('SST','USER_ENTERED')
1015: AND p2.actual_content_source IN ('SST','USER_ENTERED')

Line 1012: hz_person_profiles p2

1008: FROM (
1009: SELECT /*+ parallel(p1) parallel(p2) */
1010: max(p2.person_profile_id) old_profile_id, p1.person_profile_id new_profile_id
1011: FROM hz_person_profiles p1,
1012: hz_person_profiles p2
1013: WHERE p1.effective_end_date is null
1014: AND p1.actual_content_source IN ('SST','USER_ENTERED')
1015: AND p2.actual_content_source IN ('SST','USER_ENTERED')
1016: AND NOT EXISTS (