DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on PA_EXPENDITURE_TYPES

Line 188: pa_expenditure_types pet

184: from ap_invoice_distributions apinv,
185: pa_transaction_interface xface,
186: gms_award_distributions adl,
187: ap_invoices api,
188: pa_expenditure_types pet
189: where xface.transaction_source = G_txn_source
190: and xface.txn_interface_id = G_txn_xface_id
191: and xface.cdl_system_reference2 = apinv.invoice_id
192: and xface.cdl_system_reference5 = apinv.invoice_distribution_id --REL12 : Ap lines uptake

Line 232: pa_expenditure_types pet

228: xface.adjusted_expenditure_item_id ,
229: xface.net_zero_adjustment_flag
230: from pa_transaction_interface xface,
231: gms_award_distributions adl,
232: pa_expenditure_types pet
233: where xface.transaction_source = G_txn_source
234: and xface.cdl_system_reference2 = p_sys_ref2
235: and xface.cdl_system_reference5 = p_sys_ref5
236: and (xface.cdl_system_reference4 = p_sys_ref4 OR p_sys_ref4 IS NULL)