APPS.LNS_TERMS_PUB dependencies on LNS_RATE_SCHEDULES

Line 973: from lns_rate_schedules rs,

969: l_first_payment_date date;
970:
971: cursor c_interest_only_exists (p_loan_id number) is
972: select count(1)
973: from lns_rate_schedules rs,
974: lns_terms term
975: where term.loan_id = p_loan_id
976: and term.term_id = rs.term_id
977: and rs.interest_only_flag = 'Y'

Line 982: from lns_rate_schedules rs,

978: and rs.phase <> 'OPEN';
979:
980: cursor c_max_int_installment(p_loan_id number) is
981: select max(end_installment_number)
982: from lns_rate_schedules rs,
983: lns_terms term
984: where term.loan_id = p_loan_id
985: and term.term_id = rs.term_id
986: and rs.interest_only_flag = 'Y'