DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on HZ_RELATIONSHIPS

Line 1921: HZ_RELATIONSHIPS HR

1917: SELECT Count(*) INTO l_duplicateRow
1918: FROM HZ_PARTIES HPC,
1919: HZ_CONTACT_POINTS HCPP,
1920: HZ_CONTACT_POINTS HCPE,
1921: HZ_RELATIONSHIPS HR
1922: WHERE HR.SUBJECT_ID = l_suppPartyId
1923: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1924: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID
1925: AND HCPP.PHONE_LINE_TYPE (+) = 'GEN'