APPS.MST_WB_UTIL dependencies on HZ_PARTIES

Line 556: FROM HZ_PARTIES HZP

552: RETURN VARCHAR2 IS
553:
554: CURSOR CUR_COMPANY_NAME( P_PARTY_ID IN NUMBER ) IS
555: SELECT HZP.PARTY_NAME
556: FROM HZ_PARTIES HZP
557: WHERE HZP.PARTY_ID = P_party_id;
558:
559: CURSOR chk_owner_info(p_location_id IN NUMBER) IS
560: SELECT wlo.OWNER_TYPE, wlo.OWNER_PARTY_ID

Line 670: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HCA

666: RETURN VARCHAR2 IS
667:
668: CURSOR CUR_PARTY_NAME( P_PARTY_ID IN NUMBER ) IS
669: SELECT HZP.PARTY_NAME
670: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HCA
671: WHERE HCA.CUST_ACCOUNT_ID = P_party_id
672: AND HCA.PARTY_ID = HZP.PARTY_ID;
673:
674: CURSOR CUR_VENDOR_NAME( P_PARTY_ID IN NUMBER ) IS

Line 1064: FROM hz_parties hzp,

1060: RETURN VARCHAR2 IS
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:

Line 2344: from hz_parties hzp

2340: -- SQL repository issues as on 25-05-04:
2341: -- Removed distinct clause
2342: cursor cur_contact_name (l_contact_id in number) is
2343: SELECT hzp.party_name
2344: from hz_parties hzp
2345: where hzp.party_id = l_contact_id;
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

Line 2354: and hzcp.owner_table_name = 'HZ_PARTIES'

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'
2355: and hzcp.status = 'A';
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

Line 2364: and hzcp.owner_table_name = 'HZ_PARTIES'

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'
2365: and hzcp.status = 'A';
2366:
2367: l_contact_person varchar2(100);
2368: l_phone_num varchar2(100);

Line 2456: FROM HZ_PARTIES HZP

2452: RETURN VARCHAR2 IS
2453:
2454: CURSOR CUR_COMPANY_NAME( P_PARTY_ID IN NUMBER ) IS
2455: SELECT HZP.PARTY_NAME
2456: FROM HZ_PARTIES HZP
2457: WHERE HZP.PARTY_ID = P_party_id;
2458:
2459: l_owner_type NUMBER;
2460: l_owner_party_id NUMBER;