DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on PO_HEADERS_ALL

Line 8229: cp_vendor_id IN Po_Headers_All.vendor_id%type,

8225: WHERE customer_id = pn_cust_id
8226: AND address_id = pn_address_id;
8227:
8228: CURSOR cur_get_ser_type_vendor(
8229: cp_vendor_id IN Po_Headers_All.vendor_id%type,
8230: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type
8231: )
8232: IS
8233: SELECT service_type_code

Line 8230: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type

8226: AND address_id = pn_address_id;
8227:
8228: CURSOR cur_get_ser_type_vendor(
8229: cp_vendor_id IN Po_Headers_All.vendor_id%type,
8230: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type
8231: )
8232: IS
8233: SELECT service_type_code
8234: FROM JAI_CMN_VENDOR_SITES