APPS.IBY_PAYGROUP_PUB dependencies on AP_SUPPLIERS

Line 3154: FROM ap_suppliers asup

3150: THEN
3151: BEGIN
3152: SELECT asup.vat_registration_num
3153: INTO l_tax_registration_num(i)
3154: FROM ap_suppliers asup
3155: , ap_supplier_sites_all asups
3156: WHERE asups.vendor_site_id = p_paymentTab(i).supplier_site_id
3157: AND asup.vendor_id = asups.vendor_site_id;
3158: EXCEPTION

Line 11676: * Use AP_SUPPLIERS.NUM_1099 for the payee

11672:
11673: /*
11674: * Fix for bug 5468251:
11675: *
11676: * Use AP_SUPPLIERS.NUM_1099 for the payee
11677: * LE registration number.
11678: */
11679:
11680: /*

Line 11689: * is stored in AP_SUPPLIERS.

11685: * For employees, the payee le reg num (i.e., taxpayer id)
11686: * is stored in PER_PEOPLE_X.
11687: *
11688: * For suppliers, the payee le reg num (i.e., taxpayer id)
11689: * is stored in AP_SUPPLIERS.
11690: *
11691: * Switch between these two tables depending upon payee type
11692: * to get the payee le reg num
11693: */

Line 11701: * all non-employees will be stored in AP_SUPPLIERS.

11697: * In R12, Federal supports thid party payments i.e., payments
11698: * to third parties who may not be employees / suppliers.
11699: *
11700: * For this reason, we cannot assume that tax payer id for
11701: * all non-employees will be stored in AP_SUPPLIERS.
11702: *
11703: * However, we know that all third parties / suppliers will
11704: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
11705: * id from HZ_PARTIES as this always works.

Line 11867: AP_SUPPLIERS vendor,

11863: HZ_PARTIES payee,
11864: HZ_PARTIES invpayee,
11865:
11866: /* Vendor related */
11867: AP_SUPPLIERS vendor,
11868: AP_SUPPLIER_SITES_ALL vendor_site,
11869: AP_SUPPLIERS invvendor,
11870: AP_SUPPLIER_SITES_ALL invvendor_site,
11871:

Line 11869: AP_SUPPLIERS invvendor,

11865:
11866: /* Vendor related */
11867: AP_SUPPLIERS vendor,
11868: AP_SUPPLIER_SITES_ALL vendor_site,
11869: AP_SUPPLIERS invvendor,
11870: AP_SUPPLIER_SITES_ALL invvendor_site,
11871:
11872: /* Employee related */
11873: PER_PEOPLE_X per,

Line 12820: * Use AP_SUPPLIERS.NUM_1099 for the payee

12816:
12817: /*
12818: * Fix for bug 5468251:
12819: *
12820: * Use AP_SUPPLIERS.NUM_1099 for the payee
12821: * LE registration number.
12822: */
12823:
12824: /*

Line 12833: * is stored in AP_SUPPLIERS.

12829: * For employees, the payee le reg num (i.e., taxpayer id)
12830: * is stored in PER_PEOPLE_X.
12831: *
12832: * For suppliers, the payee le reg num (i.e., taxpayer id)
12833: * is stored in AP_SUPPLIERS.
12834: *
12835: * Switch between these two tables depending upon payee type
12836: * to get the payee le reg num
12837: */

Line 12845: * all non-employees will be stored in AP_SUPPLIERS.

12841: * In R12, Federal supports thid party payments i.e., payments
12842: * to third parties who may not be employees / suppliers.
12843: *
12844: * For this reason, we cannot assume that tax payer id for
12845: * all non-employees will be stored in AP_SUPPLIERS.
12846: *
12847: * However, we know that all third parties / suppliers will
12848: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
12849: * id from HZ_PARTIES as this always works.

Line 13010: AP_SUPPLIERS vendor,

13006: HZ_PARTIES payee,
13007: HZ_PARTIES invpayee,
13008:
13009: /* Vendor related */
13010: AP_SUPPLIERS vendor,
13011: AP_SUPPLIER_SITES_ALL vendor_site,
13012:
13013: /* Inv Vendor related */
13014: AP_SUPPLIERS invvendor,

Line 13014: AP_SUPPLIERS invvendor,

13010: AP_SUPPLIERS vendor,
13011: AP_SUPPLIER_SITES_ALL vendor_site,
13012:
13013: /* Inv Vendor related */
13014: AP_SUPPLIERS invvendor,
13015: AP_SUPPLIER_SITES_ALL invvendor_site,
13016:
13017: /* Employee related */
13018: PER_PEOPLE_X per,