APPS.OKS_CONTRACTS_PUB dependencies on HZ_CONTACT_POINTS

Line 1636: FROM hz_contact_points

1632:
1633: -- Primary telephone number
1634: CURSOR phone_cur_new( p_contact_id NUMBER ) IS
1635: SELECT contact_point_id
1636: FROM hz_contact_points
1637: WHERE contact_point_type = 'PHONE'
1638: AND NVL( phone_line_type, 'GEN' ) = 'GEN'
1639: AND primary_flag = 'Y'
1640: AND owner_table_id = p_contact_id;

Line 1645: FROM hz_contact_points

1641:
1642: -- Any one fax number
1643: CURSOR fax_cur_new( p_contact_id NUMBER ) IS
1644: SELECT contact_point_id
1645: FROM hz_contact_points
1646: WHERE contact_point_type = 'PHONE'
1647: AND phone_line_type = 'FAX'
1648: AND owner_table_id = p_contact_id;
1649: