APPS.FV_CCR_UTIL_PVT dependencies on HZ_PARTIES

Line 158: FROM hz_parties hzp, ap_suppliers pav

154:
155: SELECT hzp.party_name, NVL(pav.num_1099, pav.individual_1099),
156: pav.organization_type_lookup_code
157: INTO x_vendor_name,x_num_1099, x_org_type_lkup
158: FROM hz_parties hzp, ap_suppliers pav
159: WHERE hzp.party_id = pav.party_id
160: AND pav.vendor_id = p_vendor_id;
161:
162: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

Line 281: FROM hz_parties hzp, ap_suppliers pav

277: CURSOR vendor_taxp_csr(p_taxpayer varchar2) IS
278: --SELECT vendor_id,vendor_name FROM
279: --po_vendors WHERE num_1099 = p_taxpayer;
280: SELECT pav.vendor_id, hzp.party_name
281: FROM hz_parties hzp, ap_suppliers pav
282: WHERE (pav.num_1099 = p_taxpayer OR
283: pav.individual_1099 = p_taxpayer)
284: AND hzp.party_id = pav.party_id;
285:

Line 290: FROM hz_parties hzp, ap_suppliers pav

286: CURSOR vendor_lbn_csr(p_legal_bus varchar2) IS
287: --SELECT vendor_id,vendor_name FROM
288: --po_vendors WHERE vendor_name = p_legal_bus;
289: SELECT pav.vendor_id, hzp.party_name
290: FROM hz_parties hzp, ap_suppliers pav
291: WHERE hzp.party_name = p_legal_bus
292: AND hzp.party_id = pav.party_id;
293:
294: CURSOR vendor_supp_num_csr(p_supp_num varchar2) IS

Line 2078: UPDATE hz_parties

2074: SELECT party_id INTO l_party_id
2075: FROM ap_suppliers
2076: WHERE vendor_id = p_vendor_id;
2077:
2078: UPDATE hz_parties
2079: SET JGZZ_FISCAL_CODE = p_taxpayer_id
2080: where party_id = l_party_id;
2081:
2082: UPDATE ap_suppliers