DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on HZ_CONTACT_POINTS

Line 5814: FROM HZ_CONTACT_POINTS phone,

5810: CURSOR C_VALIDATE_PHONE_CONTACT IS
5811: SELECT 1 FROM DUAL WHERE EXISTS
5812: (
5813: SELECT phone.contact_point_id
5814: FROM HZ_CONTACT_POINTS phone,
5815: HZ_PARTIES hp
5816: WHERE HP.party_id = p_party_id --When contact is specified
5817: AND phone.owner_table_id = hp.party_id
5818: AND hp.status = 'A'

Line 5831: FROM HZ_CONTACT_POINTS phone,

5827: SELECT 1 FROM DUAL WHERE EXISTS
5828: (
5829:
5830: SELECT phone.contact_point_id
5831: FROM HZ_CONTACT_POINTS phone,
5832: HZ_PARTIES hp
5833: WHERE HP.party_id = p_cust_party_id
5834: AND phone.owner_table_id = hp.party_id
5835: AND hp.status = 'A'