DBA Data[Home] [Help]

APPS.AR_VIEW_TERM_GRP dependencies on RA_TERMS_LINES

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