APPS.JAI_PA_COSTING_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 659: from pa_transaction_interface_all

655:
656: cursor c_pa_trx_xface_records
657: is
658: select *
659: from pa_transaction_interface_all
660: where transaction_source = p_transaction_source
661: and batch_name = p_batch
662: and transaction_status_code = 'P'
663: and interface_id = p_xface_id;

Line 719: ,'Before update pa_transaction_interface_all'

715: );
716:
717: jai_cmn_debug_contexts_pkg.print
718: ( ln_reg_id
719: ,'Before update pa_transaction_interface_all'
720: );
721:
722: /*
723: update pa_transaction_interface_all

Line 723: update pa_transaction_interface_all

719: ,'Before update pa_transaction_interface_all'
720: );
721:
722: /*
723: update pa_transaction_interface_all
724: set raw_cost = raw_cost + nvl(ln_apportioned_tax_amt,0)
725: -- commented after talking to PROJECTs DEV team
726: -- ,receipt_currency_amount = receipt_currency_amount + nvl(ln_apportioned_tax_amt,0)
727: , denom_raw_cost = denom_raw_cost + nvl(ln_apportioned_tax_amt,0)

Line 731: INSERT INTO pa_transaction_interface_all(

727: , denom_raw_cost = denom_raw_cost + nvl(ln_apportioned_tax_amt,0)
728: , acct_raw_cost = acct_raw_cost + nvl(ln_apportioned_tax_amt,0)
729: where txn_interface_id = r_po_rcpt.txn_interface_id ;
730: */
731: INSERT INTO pa_transaction_interface_all(
732: TRANSACTION_SOURCE ,
733: BATCH_NAME ,
734: EXPENDITURE_ENDING_DATE ,
735: EMPLOYEE_NUMBER ,