[Home] [Help]
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:
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
227: pet.revenue_category_code,
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
237: and xface.interface_id = p_interface_id
238: and xface.TRANSACTION_STATUS_CODE = 'P'
239: and adl.expenditure_item_id = xface.adjusted_expenditure_item_id
240: and adl.adl_line_num = (SELECT max(adl1.adl_line_num)
241: FROM gms_award_distributions adl1
242: WHERE adl1.expenditure_item_id = adl.expenditure_item_id
243: AND adl1.award_id= adl.award_id
244: AND adl1.adl_status = 'A'
245: AND adl1.document_type = 'EXP')