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'
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'