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 974: FROM hz_organization_profiles p1,

970: 'N' status
971: FROM (
972: SELECT /*+ parallel(p1) parallel(p2) */
973: max(p2.organization_profile_id) old_profile_id, p1.organization_profile_id new_profile_id
974: FROM hz_organization_profiles p1,
975: hz_organization_profiles p2
976: WHERE p1.effective_end_date is null
977: AND NOT EXISTS (
978: SELECT null

Line 975: hz_organization_profiles p2

971: FROM (
972: SELECT /*+ parallel(p1) parallel(p2) */
973: max(p2.organization_profile_id) old_profile_id, p1.organization_profile_id new_profile_id
974: FROM hz_organization_profiles p1,
975: hz_organization_profiles p2
976: WHERE p1.effective_end_date is null
977: AND NOT EXISTS (
978: SELECT null
979: FROM hz_org_profiles_ext_b ext