APPS.JG_TAXID_VAL_PKG dependencies on PO_VENDORS

Line 120: FROM PO_VENDORS AP

116: 'PARTNERSHIP',AP.INDIVIDUAL_1099,
117: 'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
118: AP.NUM_1099),
119: AP.NUM_1099) NUM_1099
120: FROM PO_VENDORS AP
121: WHERE decode(ap.vendor_type_lookup_code,'Contractor',
122: decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
123: 'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,
124: 'PARTNERSHIP',AP.INDIVIDUAL_1099,

Line 230: SELECT AP.VAT_REGISTRATION_NUM FROM PO_VENDORS AP

226: AND AR.CUSTOMER_ID <>nvl(p_record_id,0)
227: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
228:
229: CURSOR CHECK_UNIQUE_TAX_REG_NUM_AP IS -- Suppliers
230: SELECT AP.VAT_REGISTRATION_NUM FROM PO_VENDORS AP
231: WHERE AP.VAT_REGISTRATION_NUM = p_tax_reg_num
232: AND AP.VENDOR_ID<>nvl(p_record_id,0)
233: AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
234:

Line 369: AP.GLOBAL_ATTRIBUTE10 FROM PO_VENDORS AP

365: 'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
366: AP.NUM_1099),
367: AP.NUM_1099) NUM_1099,
368: AP.GLOBAL_ATTRIBUTE9,
369: AP.GLOBAL_ATTRIBUTE10 FROM PO_VENDORS AP
370: WHERE (AP.VENDOR_NAME=p_entity_name
371: OR decode(ap.vendor_type_lookup_code,'Contractor',
372: decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
373: 'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,