APPS.FV_CCR_UTIL_PVT dependencies on AP_SUPPLIERS

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 185: UPDATE ap_suppliers

181: fnd_file.put_line(fnd_file.log, 'p_vend_org_type: '||p_vend_org_type);
182:
183: x_status := 'E';
184:
185: UPDATE ap_suppliers
186: SET organization_type_lookup_code = p_vend_org_type
187: WHERE vendor_id = p_vendor_id;
188:
189: IF(SQL%NOTFOUND) THEN

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 297: FROM ap_suppliers

293:
294: CURSOR vendor_supp_num_csr(p_supp_num varchar2) IS
295: SELECT segment1
296: --FROM po_vendors
297: FROM ap_suppliers
298: where segment1 = p_supp_num;
299:
300:
301: BEGIN

Line 750: l_legal_bus_name ap_suppliers.vendor_name%TYPE;

746: l_party_site_id NUMBER;
747:
748: l_org_type_lookup po_lookup_codes.lookup_code%TYPE;
749:
750: l_legal_bus_name ap_suppliers.vendor_name%TYPE;
751: l_count NUMBER;
752:
753: BEGIN
754:

Line 763: FROM ap_suppliers

759: l_count := 0;
760:
761: SELECT 1
762: INTO l_count
763: FROM ap_suppliers
764: WHERE vendor_name = l_legal_bus_name
765: AND num_1099 <> p_taxpayer_number;
766:
767: fv_utility.log_mesg('Another vendor exists with the same

Line 2075: FROM ap_suppliers

2071:
2072: x_status := 'E';
2073:
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

Line 2082: UPDATE ap_suppliers

2078: UPDATE hz_parties
2079: SET JGZZ_FISCAL_CODE = p_taxpayer_id
2080: where party_id = l_party_id;
2081:
2082: UPDATE ap_suppliers
2083: SET num_1099 = p_taxpayer_id
2084: WHERE vendor_id = p_vendor_id;
2085:
2086: x_status := 'S';

Line 2744: FROM ap_suppliers

2740: l_login_id := fnd_global.login_id;
2741:
2742: SELECT party_id,vendor_type_lookup_code
2743: INTO l_party_id,l_vendor_type_lookup_code
2744: FROM ap_suppliers
2745: WHERE vendor_id=p_vendor_id;
2746:
2747: SELECT party_site_id INTO l_party_site_id
2748: FROM ap_supplier_sites_all