APPS.AR_GTA_TRX_UTIL dependencies on HZ_CONTACT_POINTS

Line 1643: l_phone_number hz_contact_points.phone_number%TYPE;

1639: )
1640: RETURN VARCHAR2
1641: IS
1642: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
1643: l_phone_number hz_contact_points.phone_number%TYPE;
1644:
1645: --Fix bug 5263009, Donghai Wang
1646: --Add the sub query to get party id by customer id
1647: CURSOR c_phone_number

Line 1652: hz_contact_points hcp

1648: IS
1649: SELECT
1650: hcp.phone_number
1651: FROM
1652: hz_contact_points hcp
1653: WHERE hcp.contact_point_type = 'PHONE'
1654: AND hcp.owner_table_name = 'HZ_PARTIES'
1655: AND hcp.owner_table_id = (SELECT
1656: party_id