APPS.AP_PA_API_PKG dependencies on AP_INVOICES_ALL

Line 13: FROM ap_invoices_all

9: IS
10: l_org_Id number;
11: Cursor select_org_id is
12: SELECT org_id
13: FROM ap_invoices_all
14: WHERE invoice_id = P_Invoice_Id;
15: Begin
16: OPEN select_org_id;
17: FETCH select_org_id INTO l_org_Id;

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(*)