DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 3121: FROM hz_party_usg_assignments

3117: AND party_usage_code = 'SUPPLIER'
3118: AND RELATED_PARTY_USAGE_CODE = 'CUSTOMER'
3119: AND EXISTS
3120: (SELECT 1
3121: FROM hz_party_usg_assignments
3122: WHERE party_id = l_party_id
3123: AND party_usage_code = 'SUPPLIER'
3124: )
3125: AND NVL(EFFECTIVE_START_DATE, sysdate-1) < sysdate