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 230: PA_EXPENDITURE_TYPES PET

226: FROM AP_SELF_ASSESSED_TAX_DIST apsat,
227: pa_transaction_interface xface,
228: gms_award_distributions adl,
229: ap_invoices api,
230: PA_EXPENDITURE_TYPES PET
231: where xface.transaction_source = G_txn_source
232: and XFACE.TXN_INTERFACE_ID = G_TXN_XFACE_ID
233: and XFACE.CDL_SYSTEM_REFERENCE2 = APSAT.INVOICE_ID
234: and XFACE.CDL_SYSTEM_REFERENCE5 = APSAT.INVOICE_DISTRIBUTION_ID

Line 274: pa_expenditure_types pet

270: xface.adjusted_expenditure_item_id ,
271: xface.net_zero_adjustment_flag
272: from pa_transaction_interface xface,
273: gms_award_distributions adl,
274: pa_expenditure_types pet
275: where xface.transaction_source = G_txn_source
276: and xface.cdl_system_reference2 = p_sys_ref2
277: and xface.cdl_system_reference5 = p_sys_ref5
278: and (xface.cdl_system_reference4 = p_sys_ref4 OR p_sys_ref4 IS NULL)