APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_TERMS

Line 1230: FROM ra_terms_lines tl,

1226: ),
1227: p_trx_date + tl.due_days
1228: )
1229: INTO l_term_due_date
1230: FROM ra_terms_lines tl,
1231: ra_terms t
1232: WHERE tl.term_id = p_term_id
1233: AND t.term_id = tl.term_id
1234: AND tl.sequence_num = (

Line 1231: ra_terms t

1227: p_trx_date + tl.due_days
1228: )
1229: INTO l_term_due_date
1230: FROM ra_terms_lines tl,
1231: ra_terms t
1232: WHERE tl.term_id = p_term_id
1233: AND t.term_id = tl.term_id
1234: AND tl.sequence_num = (
1235: SELECT MIN(sequence_num)

Line 1236: FROM ra_terms_lines

1232: WHERE tl.term_id = p_term_id
1233: AND t.term_id = tl.term_id
1234: AND tl.sequence_num = (
1235: SELECT MIN(sequence_num)
1236: FROM ra_terms_lines
1237: WHERE term_id = p_term_id
1238: );
1239: END IF;
1240:

Line 1348: FROM ra_terms_lines

1344: THEN
1345:
1346: SELECT COUNT(*)
1347: INTO l_count
1348: FROM ra_terms_lines
1349: WHERE term_id = p_term_id;
1350:
1351: END IF;
1352:

Line 2214: FROM ra_terms

2210: ELSE
2211:
2212: SELECT name,calc_discount_on_lines_flag,partial_discount_flag
2213: INTO l_name, l_calc_disc_on_lines_flag, l_partial_discount_flag
2214: FROM ra_terms
2215: WHERE term_id = p_term_id;
2216:
2217: pg_term_rec(p_term_id).partial_discount_flag := l_partial_discount_flag;
2218: pg_term_rec(p_term_id).calc_disc_on_lines_flag := l_calc_disc_on_lines_flag;