APPS.XTR_BISF_P dependencies on XTR_JOURNALS

Line 74: from xtr_journals

70: l_prev_journal_date date;
71:
72: cursor ig_get_prev_intset is
73: select journal_date
74: from xtr_journals
75: where deal_type=p_deal_type and
76: deal_number=p_deal_number and
77: amount_type in ('INTSET','COMPOND') and
78: journal_date < p_journal_date and

Line 84: from xtr_journals

80: order by journal_date desc;
81:
82: cursor ig_sum_intadj(p_prev_journal_date date) is
83: select sum(ACCOUNTED_DR)
84: from xtr_journals
85: where deal_type=p_deal_type and
86: deal_number=p_deal_number and
87: amount_type ='INTADJ' and
88: journal_date > p_prev_journal_date and

Line 94: from xtr_journals

90: accounted_dr <>0;
91:
92: cursor onc_get_prev_intset is
93: select journal_date
94: from xtr_journals
95: where deal_type=p_deal_type and
96: deal_number=p_deal_number and
97: amount_type ='INTSET' and
98: accounted_dr <> 0 and

Line 109: from xtr_journals

105:
106:
107: cursor onc_sum_intadj is
108: select sum(ACCOUNTED_DR)
109: from xtr_journals
110: where deal_type=p_deal_type and
111: deal_number=p_deal_number and
112: amount_type ='INTADJ' and
113: journal_date > l_prev_journal_date and