DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_EXPENDITURE_TYPES

Line 458: PA_EXPENDITURE_TYPES TYPE

454: FROM PO_Vendors VEND,
455: AP_Invoices INV,
456: AP_Invoice_Lines INVL,
457: PA_Transfer_AP_Invoices_View DIST,
458: PA_EXPENDITURE_TYPES TYPE
459: WHERE DIST.Invoice_Id = INV.Invoice_Id
460: AND INVL.Invoice_id = INV.Invoice_Id
461: AND INVL.Line_Number = DIST.Invoice_Line_Number
462: AND INVL.Invoice_Id = DIST.Invoice_Id

Line 682: pa_expenditure_types type

678: po_headers_all po_head,
679: po_lines_all po_line,
680: po_distributions_all po_dist,
681: po_vendors vend,
682: pa_expenditure_types type
683: where ((rcv_txn.destination_type_code ='EXPENSE' ) OR
684: (rcv_txn.destination_type_code='RECEIVING' AND
685: (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))
686: )

Line 931: PA_EXPENDITURE_TYPES TYPE,

927: ap_payment_hist_dists Paydist,
928: PO_Vendors VEND,
929: AP_Invoices INV,
930: Ap_Invoice_Distributions DIST,
931: PA_EXPENDITURE_TYPES TYPE,
932: ap_checks chk
933: WHERE DIST.Invoice_Id = INV.Invoice_Id
934: AND Pay.Invoice_Payment_Id = Paydist.Invoice_payment_id
935: AND Pay.check_id = chk.check_id

Line 1032: PA_EXPENDITURE_TYPES TYPE

1028: AP_INVOICE_DISTRIBUTIONS DIST2,
1029: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1030: --PA_Transfer_AP_Invoices_View DIST1,
1031: -- PA_Transfer_AP_Invoices_View DIST2,
1032: PA_EXPENDITURE_TYPES TYPE
1033: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1034: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied
1035: AND DIST2.invoice_id = DIST1.invoice_id
1036: AND DIST2.invoice_distribution_id = PDIST.prepay_app_distribution_id --Prepay appl line