APPS.XTR_BISF_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 44: from xtr_rollover_transactions

40: where deal_no=to_number(p_deal_number);
41:
42: cursor ro_ref_int is
43: select internal_ticket_no
44: from xtr_rollover_transactions
45: where deal_number=to_number(p_deal_number)
46: and transaction_number=p_transaction_number;
47:
48: Begin

Line 100: transaction_number in (select a.transaction_number from xtr_rollover_transactions a

96: deal_number=p_deal_number and
97: amount_type ='INTSET' and
98: accounted_dr <> 0 and
99: journal_date < p_journal_date and
100: transaction_number in (select a.transaction_number from xtr_rollover_transactions a
101: where a.deal_number=p_deal_number
102: start with a.cross_ref_to_trans = p_transaction_number
103: connect by (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number))
104: order by journal_date desc;

Line 116: transaction_number in (select a.transaction_number from xtr_rollover_transactions a

112: amount_type ='INTADJ' and
113: journal_date > l_prev_journal_date and
114: journal_date <= p_journal_date and
115: accounted_dr <> 0 and
116: transaction_number in (select a.transaction_number from xtr_rollover_transactions a
117: where a.deal_number=p_deal_number
118: start with a.cross_ref_to_trans = p_transaction_number
119: connect by (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number));
120: