APPS.PAAPIMP_PKG dependencies on PA_EXPENDITURE_TYPES

Line 453: PA_EXPENDITURE_TYPES TYPE

449: FROM PO_Vendors VEND,
450: AP_Invoices INV,
451: AP_Invoice_Lines INVL,
452: PA_Transfer_AP_Invoices_View DIST,
453: PA_EXPENDITURE_TYPES TYPE
454: WHERE DIST.Invoice_Id = INV.Invoice_Id
455: AND INVL.Invoice_id = INV.Invoice_Id
456: AND INVL.Line_Number = DIST.Invoice_Line_Number
457: AND INVL.Invoice_Id = DIST.Invoice_Id

Line 675: pa_expenditure_types type

671: po_headers_all po_head,
672: po_lines_all po_line,
673: po_distributions_all po_dist,
674: po_vendors vend,
675: pa_expenditure_types type
676: where ((rcv_txn.destination_type_code ='EXPENSE' ) OR
677: (rcv_txn.destination_type_code='RECEIVING' AND
678: (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))
679: )

Line 924: PA_EXPENDITURE_TYPES TYPE,

920: ap_payment_hist_dists Paydist,
921: PO_Vendors VEND,
922: AP_Invoices INV,
923: Ap_Invoice_Distributions DIST,
924: PA_EXPENDITURE_TYPES TYPE,
925: ap_checks chk
926: WHERE DIST.Invoice_Id = INV.Invoice_Id
927: AND Pay.Invoice_Payment_Id = Paydist.Invoice_payment_id
928: AND Pay.check_id = chk.check_id

Line 1025: PA_EXPENDITURE_TYPES TYPE

1021: AP_INVOICE_DISTRIBUTIONS DIST2,
1022: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1023: --PA_Transfer_AP_Invoices_View DIST1,
1024: -- PA_Transfer_AP_Invoices_View DIST2,
1025: PA_EXPENDITURE_TYPES TYPE
1026: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1027: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied
1028: AND DIST2.invoice_id = DIST1.invoice_id
1029: AND DIST2.invoice_distribution_id = PDIST.prepay_app_distribution_id --Prepay appl line