DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on AP_SUPPLIER_SITES_ALL

Line 7252: FROM ap_supplier_sites_all

7248: THEN
7249: BEGIN
7250: SELECT vat_registration_num
7251: INTO l_tax_registration_num(i)
7252: FROM ap_supplier_sites_all
7253: WHERE vendor_site_id = p_paymentTab(i).supplier_site_id;
7254:
7255: EXCEPTION
7256: WHEN NO_DATA_FOUND

Line 7262: , ap_supplier_sites_all asups

7258: BEGIN
7259: SELECT asup.vat_registration_num
7260: INTO l_tax_registration_num(i)
7261: FROM ap_suppliers asup
7262: , ap_supplier_sites_all asups
7263: WHERE asups.vendor_site_id = p_paymentTab(i).supplier_site_id
7264: AND asup.vendor_id = asups.vendor_id;
7265: EXCEPTION
7266: WHEN OTHERS THEN

Line 24216: AP_SUPPLIER_SITES_ALL vendor_site

24212:
24213: FROM
24214: /* Vendor related */
24215: AP_SUPPLIERS vendor,
24216: AP_SUPPLIER_SITES_ALL vendor_site
24217: -- PER_PEOPLE_X per
24218:
24219: WHERE
24220:

Line 26070: AP_SUPPLIER_SITES_ALL invvendor_site

26066: HZ_PARTIES invpayee,
26067: HZ_PARTY_SITES invpayee_site,
26068:
26069: AP_SUPPLIERS invvendor,
26070: AP_SUPPLIER_SITES_ALL invvendor_site
26071:
26072:
26073: WHERE
26074: /*Bug 13540717 --Start Modify*/