DBA Data[Home] [Help]

APPS.JAI_AR_TRX_LINES_PKG dependencies on PO_HEADERS_ALL

Line 999: CURSOR cur_get_ser_type_vendor(cp_vendor_id IN Po_Headers_All.vendor_id%type,

995: FROM JAI_CMN_CUS_ADDRESSES
996: WHERE customer_id = pn_cust_id
997: AND address_id = pn_address_id;
998:
999: CURSOR cur_get_ser_type_vendor(cp_vendor_id IN Po_Headers_All.vendor_id%type,
1000: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type) IS
1001: SELECT service_type_code
1002: FROM JAI_CMN_VENDOR_SITES
1003: WHERE vendor_id = cp_vendor_id

Line 1000: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type) IS

996: WHERE customer_id = pn_cust_id
997: AND address_id = pn_address_id;
998:
999: CURSOR cur_get_ser_type_vendor(cp_vendor_id IN Po_Headers_All.vendor_id%type,
1000: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type) IS
1001: SELECT service_type_code
1002: FROM JAI_CMN_VENDOR_SITES
1003: WHERE vendor_id = cp_vendor_id
1004: AND vendor_site_id = cp_vendor_site_id;