APPS.LNS_BILLING_UTIL_PUB dependencies on RA_TERMS

Line 1277: FROM RA_TERMS term,

1273: where org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
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

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

Line 1291: FROM RA_TERMS

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
1292: WHERE TERM_ID = P_TERM_ID;
1293:
1294: BEGIN
1295: