APPS.GMS_PA_COSTING_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 145: TYPE tt_burdenable_raw_cost is table of gms_award_distributions.burdenable_raw_cost%TYPE;

141: TYPE tt_revenue_category is table of gms_bc_packets.revenue_category%TYPE;
142: TYPE tt_adjusted_document_header_id is table of gms_bc_packets.adjusted_document_header_id%TYPE;
143: TYPE tt_award_set_id is table of gms_bc_packets.award_set_id%TYPE;
144: TYPE tt_transaction_source is table of gms_bc_packets.transaction_source%TYPE;
145: TYPE tt_burdenable_raw_cost is table of gms_award_distributions.burdenable_raw_cost%TYPE;
146: TYPE tt_acct_raw_cost is table of pa_transaction_interface_all.acct_raw_cost%TYPE;
147: TYPE tt_line_type_lookup is table of ap_invoice_distributions_all.line_type_lookup_code%TYPE;
148: TYPE tt_invoice_type_lookup is table of ap_invoices_all.invoice_type_lookup_code%TYPE;
149:

Line 186: gms_award_distributions adl,

182: , xface.net_zero_adjustment_flag
183: , adl.fc_status -- R12 AP lines uptake : Prepayment changes
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

Line 228: gms_award_distributions adl,

224: xface.net_zero_adjustment_flag ,
225: ADL.FC_STATUS
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

Line 273: gms_award_distributions adl,

269: pet.revenue_category_code,
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

Line 283: FROM gms_award_distributions adl1

279: and xface.interface_id = p_interface_id
280: and xface.TRANSACTION_STATUS_CODE = 'P'
281: and adl.expenditure_item_id = xface.adjusted_expenditure_item_id
282: and adl.adl_line_num = (SELECT max(adl1.adl_line_num)
283: FROM gms_award_distributions adl1
284: WHERE adl1.expenditure_item_id = adl.expenditure_item_id
285: AND adl1.award_id= adl.award_id
286: AND adl1.adl_status = 'A'
287: AND adl1.document_type = 'EXP')