APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 106: ELSIF p_owner_table_name = 'HZ_ORGANIZATION_PROFILES' THEN

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';
108: l_object_type := 'ORG';
109: ELSIF p_owner_table_name = 'HZ_LOCATIONS' THEN
110: l_pk_column_name := 'LOCATION_ID';

Line 978: FROM hz_organization_profiles p1,

974: 'N' status
975: FROM (
976: SELECT /*+ parallel(p1) parallel(p2) */
977: max(p2.organization_profile_id) old_profile_id, p1.organization_profile_id new_profile_id
978: FROM hz_organization_profiles p1,
979: hz_organization_profiles p2
980: WHERE p1.effective_end_date is null
981: AND p1.actual_content_source IN ('SST','USER_ENTERED')
982: AND p2.actual_content_source IN ('SST','USER_ENTERED')

Line 979: hz_organization_profiles p2

975: FROM (
976: SELECT /*+ parallel(p1) parallel(p2) */
977: max(p2.organization_profile_id) old_profile_id, p1.organization_profile_id new_profile_id
978: FROM hz_organization_profiles p1,
979: hz_organization_profiles p2
980: WHERE p1.effective_end_date is null
981: AND p1.actual_content_source IN ('SST','USER_ENTERED')
982: AND p2.actual_content_source IN ('SST','USER_ENTERED')
983: AND NOT EXISTS (