APPS.LNS_BILLING_UTIL_PUB dependencies on RA_TERMS_LINES

Line 1278: ra_terms_lines line

1274:
1275: CURSOR validate_ra_term(P_TERM_ID IN NUMBER) IS
1276: SELECT line.DUE_DAYS, term.NAME
1277: FROM RA_TERMS term,
1278: ra_terms_lines line
1279: WHERE line.TERM_ID = P_TERM_ID and
1280: line.DUE_DAYS is not null and
1281: line.DUE_DATE is null and
1282: line.DUE_DAY_OF_MONTH is null and

Line 1287: (SELECT count(1) FROM ra_terms_lines WHERE term_id = line.TERM_ID) = 1;

1283: line.DUE_MONTHS_FORWARD is null and
1284: line.RELATIVE_AMOUNT = 100 and
1285: term.term_id = line.TERM_ID and
1286: term.BILLING_CYCLE_ID IS NULL and
1287: (SELECT count(1) FROM ra_terms_lines WHERE term_id = line.TERM_ID) = 1;
1288:
1289: CURSOR get_term(P_TERM_ID IN NUMBER) IS
1290: SELECT NAME
1291: FROM RA_TERMS