APPS.MST_WB_UTIL dependencies on HZ_CONTACT_POINTS

Line 1065: HZ_CONTACT_POINTS hzcp

1061:
1062: CURSOR cur_contact IS
1063: SELECT hzp.party_name
1064: FROM hz_parties hzp,
1065: HZ_CONTACT_POINTS hzcp
1066: WHERE hzp.party_id = hzcp.owner_table_id
1067: AND hzcp.CONTACT_POINT_ID = p_contact_id;
1068:
1069: l_Contact VARCHAR2(100);

Line 1086: FROM HZ_CONTACT_POINTS hzcp

1082: RETURN VARCHAR2 IS
1083:
1084: CURSOR cur_phone IS
1085: SELECT hzcp.PHONE_NUMBER
1086: FROM HZ_CONTACT_POINTS hzcp
1087: WHERE hzcp.CONTACT_POINT_ID = p_contact_id;
1088:
1089: l_Phone VARCHAR2(100);
1090: BEGIN

Line 2350: from hz_contact_points hzcp

2346:
2347: cursor cur_prim_contact (l_contact_id in number, l_ret_str_type in varchar2) is
2348: select hzcp.phone_country_code||'-'||hzcp.phone_area_code||'-'||hzcp.phone_number||'-'||hzcp.phone_extension
2349: , hzcp.email_address
2350: from hz_contact_points hzcp
2351: where hzcp.owner_table_id = l_contact_id
2352: and hzcp.contact_point_type = l_ret_str_type
2353: and hzcp.primary_flag = 'Y'
2354: and hzcp.owner_table_name = 'HZ_PARTIES'

Line 2360: from hz_contact_points hzcp

2356:
2357: cursor cur_sec_contact (l_contact_id in number, l_ret_str_type in varchar2) is
2358: select hzcp.phone_country_code||'-'||hzcp.phone_area_code||'-'||hzcp.phone_number||'-'||hzcp.phone_extension
2359: , hzcp.email_address
2360: from hz_contact_points hzcp
2361: where hzcp.owner_table_id = l_contact_id
2362: and hzcp.contact_point_type = l_ret_str_type
2363: and hzcp.primary_flag = 'N'
2364: and hzcp.owner_table_name = 'HZ_PARTIES'