APPS.AR_VIEW_TERM_GRP dependencies on RA_TERMS

Line 92: FROM ra_terms

88:
89: CURSOR c_term(p_term_id IN NUMBER) IS
90: SELECT NVL(base_amount,100),
91: first_installment_code
92: FROM ra_terms
93: WHERE term_id = p_term_id;
94:
95: CURSOR c_term_line (p_term_id IN NUMBER) IS
96: SELECT NVL(SUM(tl.relative_amount),0),

Line 98: FROM ra_terms_lines tl

94:
95: CURSOR c_term_line (p_term_id IN NUMBER) IS
96: SELECT NVL(SUM(tl.relative_amount),0),
97: NVL(SUM(DECODE(tl.sequence_num,1,1,0)),0)
98: FROM ra_terms_lines tl
99: WHERE tl.term_id = p_term_id
100: AND tl.due_days = 0;
101:
102: BEGIN