DBA Data[Home] [Help]

APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 684: FROM xtr_rollover_transactions

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

Line 691: FROM xtr_deal_date_amounts dda, xtr_rollover_transactions rt

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