APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_TERMS

Line 1320: FROM ra_terms_lines tl,

1316: ),
1317: p_trx_date + tl.due_days
1318: )
1319: INTO l_term_due_date
1320: FROM ra_terms_lines tl,
1321: ra_terms t
1322: WHERE tl.term_id = p_term_id
1323: AND t.term_id = tl.term_id
1324: AND tl.sequence_num = (

Line 1321: ra_terms t

1317: p_trx_date + tl.due_days
1318: )
1319: INTO l_term_due_date
1320: FROM ra_terms_lines tl,
1321: ra_terms t
1322: WHERE tl.term_id = p_term_id
1323: AND t.term_id = tl.term_id
1324: AND tl.sequence_num = (
1325: SELECT MIN(sequence_num)

Line 1326: FROM ra_terms_lines

1322: WHERE tl.term_id = p_term_id
1323: AND t.term_id = tl.term_id
1324: AND tl.sequence_num = (
1325: SELECT MIN(sequence_num)
1326: FROM ra_terms_lines
1327: WHERE term_id = p_term_id
1328: );
1329: END IF;
1330:

Line 1438: FROM ra_terms_lines

1434: THEN
1435:
1436: SELECT COUNT(*)
1437: INTO l_count
1438: FROM ra_terms_lines
1439: WHERE term_id = p_term_id;
1440:
1441: END IF;
1442:

Line 2333: FROM ra_terms

2329: ELSE
2330:
2331: SELECT name,calc_discount_on_lines_flag,partial_discount_flag
2332: INTO l_name, l_calc_disc_on_lines_flag, l_partial_discount_flag
2333: FROM ra_terms
2334: WHERE term_id = p_term_id;
2335:
2336: pg_term_rec(p_term_id).partial_discount_flag := l_partial_discount_flag;
2337: pg_term_rec(p_term_id).calc_disc_on_lines_flag := l_calc_disc_on_lines_flag;