APPS.FV_CCR_UTIL_PVT dependencies on AP_SUPPLIERS

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

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

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

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

Line 720: l_legal_bus_name ap_suppliers.vendor_name%TYPE;

716: l_party_site_id NUMBER;
717:
718: l_org_type_lookup po_lookup_codes.lookup_code%TYPE;
719:
720: l_legal_bus_name ap_suppliers.vendor_name%TYPE;
721: l_count NUMBER;
722: l_party_id NUMBER;
723:
724: /*Added for bug 9320586 Starting*/

Line 813: FROM ap_suppliers

809: l_count := 0;
810:
811: SELECT 1
812: INTO l_count
813: FROM ap_suppliers
814: WHERE vendor_name = l_legal_bus_name
815: AND num_1099 <> p_taxpayer_number;
816:
817: fv_utility.log_mesg('Another vendor exists with the same

Line 1789: FROM ap_suppliers

1785: if l_affected_inv_cnt > 0 then
1786: --Bug14373735
1787: SELECT party_id
1788: INTO l_party_id
1789: FROM ap_suppliers
1790: WHERE vendor_id = l_vendor_id;
1791:
1792: AP_AUTOMATIC_PROPAGATION_PKG.Update_Payment_Schedules (
1793: p_from_bank_account_id => p_old_bank_account_id,

Line 2296: FROM ap_suppliers

2292:
2293: x_status := 'E';
2294:
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

Line 2308: UPDATE ap_suppliers

2304: update hz_organization_profiles
2305: set JGZZ_FISCAL_CODE = p_taxpayer_id
2306: where party_id = l_party_id;
2307:
2308: UPDATE ap_suppliers
2309: SET num_1099 = p_taxpayer_id
2310: WHERE vendor_id = p_vendor_id;
2311:
2312: x_status := 'S';

Line 3046: FROM ap_suppliers

3042: l_login_id := fnd_global.login_id;
3043:
3044: SELECT party_id,vendor_type_lookup_code
3045: INTO l_party_id,l_vendor_type_lookup_code
3046: FROM ap_suppliers
3047: WHERE vendor_id=p_vendor_id;
3048:
3049: SELECT party_site_id INTO l_party_site_id
3050: FROM ap_supplier_sites_all

Line 3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;

3225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3226:
3227: begin
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;
3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;
3230:
3231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ccr_tin: '||l_ccr_tin);
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_tin: '||l_supplier_tin);
3233: