DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on AP_INVOICES_ALL

Line 358: FROM AP_Invoices_All INV,

354: , DIST.Base_Amount Base_Charge_Amount
355: , DIST.PO_Distribution_Id PO_Distribution_Id
356: , DIST.RCV_Transaction_Id RCV_Transaction_Id
357: , DIST.Line_Type_Lookup_Code Line_Type_Lookup_Code
358: FROM AP_Invoices_All INV,
359: (SELECT Invoice_Distribution_Id
360: , Invoice_Id
361: , Project_Id
362: , Task_id

Line 425: FROM AP_Invoices_All INV,

421: , DIST.Base_Amount Base_Charge_Amount
422: , DIST.PO_Distribution_Id PO_Distribution_Id
423: , DIST.RCV_Transaction_Id RCV_Transaction_Id
424: , DIST.Line_Type_Lookup_Code Line_Type_Lookup_Code
425: FROM AP_Invoices_All INV,
426: (SELECT C.Invoice_Distribution_Id
427: , C.Invoice_Id
428: , P.Project_Id
429: , P.Task_Id

Line 495: FROM AP_Invoices_All INV,

491: , DIST.Base_Amount Base_Charge_Amount
492: , DIST.PO_Distribution_Id PO_Distribution_Id
493: , DIST.RCV_Transaction_Id RCV_Transaction_Id
494: , DIST.Line_Type_Lookup_Code Line_Type_Lookup_Code
495: FROM AP_Invoices_All INV,
496: (SELECT Invoice_Distribution_Id
497: , Invoice_Id
498: , Project_Id
499: , Task_id

Line 564: FROM AP_Invoices_All INV,

560: , DIST.Base_Amount Base_Charge_Amount
561: , DIST.PO_Distribution_Id PO_Distribution_Id
562: , DIST.RCV_Transaction_Id RCV_Transaction_Id
563: , DIST.Line_Type_Lookup_Code Line_Type_Lookup_Code
564: FROM AP_Invoices_All INV,
565: (SELECT C.Invoice_Distribution_Id
566: , C.Invoice_Id
567: , P.Project_Id
568: , P.Task_Id

Line 2465: from AP_Invoices_All

2461: -- Obtain Invoice_date
2462: -------------------------
2463: select invoice_date
2464: into l_invoice_date
2465: from AP_Invoices_All
2466: where invoice_id = P_Invoice_ID;
2467:
2468: ----------------------------
2469: -- Obtain expenditure type