APPS.FV_CCR_UTIL_PVT dependencies on HZ_PARTIES

Line 161: FROM hz_parties hzp, ap_suppliers pav

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

Line 284: FROM hz_parties hzp, ap_suppliers pav

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

Line 293: FROM hz_parties hzp, ap_suppliers pav

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

Line 2299: UPDATE hz_parties

2295: SELECT party_id INTO l_party_id
2296: FROM ap_suppliers
2297: WHERE vendor_id = p_vendor_id;
2298:
2299: UPDATE hz_parties
2300: SET JGZZ_FISCAL_CODE = p_taxpayer_id
2301: where party_id = l_party_id;
2302:
2303: