APPS.JMF_GTA_TRX_UTIL dependencies on HZ_CONTACT_POINTS

Line 1436: l_phone_number hz_contact_points.phone_number%TYPE;

1432: )
1433: RETURN VARCHAR2
1434: IS
1435: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
1436: l_phone_number hz_contact_points.phone_number%TYPE;
1437:
1438: --Fix bug 5263009, Donghai Wang
1439: --Add the sub query to get party id by customer id
1440: CURSOR c_phone_number

Line 1445: hz_contact_points hcp

1441: IS
1442: SELECT
1443: hcp.phone_number
1444: FROM
1445: hz_contact_points hcp
1446: WHERE hcp.contact_point_type = 'PHONE'
1447: AND hcp.owner_table_name = 'HZ_PARTIES'
1448: AND hcp.owner_table_id = (SELECT
1449: party_id