DBA Data[Home] [Help]

APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 685: FROM xtr_rollover_transactions

681: l_date DATE;
682:
683: CURSOR get_later_trans IS
684: SELECT transaction_number
685: FROM xtr_rollover_transactions
686: WHERE deal_number = p_deal_number
687: AND maturity_date > l_date
688: AND tax_amount IS NOT NULL;
689:

Line 692: FROM xtr_deal_date_amounts dda, xtr_rollover_transactions rt

688: AND tax_amount IS NOT NULL;
689:
690: CURSOR chk_tax_settle is
691: SELECT 1
692: FROM xtr_deal_date_amounts dda, xtr_rollover_transactions rt
693: WHERE rt.deal_number=p_deal_number
694: AND rt.transaction_number=v_trans_no
695: AND dda.settle='Y'
696: AND dda.deal_number=0