DBA Data[Home] [Help]

APPS.AP_PA_API_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 144: FROM ap_invoices_all, ap_system_parameters_all

140: var_cancelled_by,
141: var_payment_status_flag,
142: var_allow_paid_invoice_adjust,
143: var_invoice_type_lookup_code
144: FROM ap_invoices_all, ap_system_parameters_all
145: WHERE nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)
146: AND invoice_id = X_Invoice_Id;
147:
148: SELECT count(*)

Line 145: WHERE nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)

141: var_payment_status_flag,
142: var_allow_paid_invoice_adjust,
143: var_invoice_type_lookup_code
144: FROM ap_invoices_all, ap_system_parameters_all
145: WHERE nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)
146: AND invoice_id = X_Invoice_Id;
147:
148: SELECT count(*)
149: INTO accrue_on_receipt_num