eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_TERMS_LINES

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 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: