APPS.AP_XML_INVOICE_INBOUND_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 35: from ap_system_parameters_all sys,ap_invoices_interface h

31:
32: update ap_invoice_lines_interface
33: set DIST_CODE_COMBINATION_ID =
34: (select FREIGHT_CODE_COMBINATION_ID
35: from ap_system_parameters_all sys,ap_invoices_interface h
36: where sys.org_id = h.org_id and h.invoice_id = p_invoice_id)
37: where line_type_lookup_code = 'FREIGHT' and
38: invoice_id = p_invoice_id;
39:

Line 923: FROM AP_SYSTEM_PARAMETERS_ALL

919:
920: -- fetch setup info
921: SELECT FREIGHT_CODE_COMBINATION_ID
922: INTO l_freight_ccid
923: FROM AP_SYSTEM_PARAMETERS_ALL
924: WHERE NVL(ORG_ID,TO_NUMBER(NVL(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
925: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10)), '-99'))) =
926: NVL(l_org_id,TO_NUMBER(NVL(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
927: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10)), '-99')));