APPS.LNS_FIN_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 72

    SELECT to_number(TO_CHAR(p_date, 'J'))
      INTO l_num
      FROM DUAL;

Line: 1123

  SELECT
         t.loan_payment_frequency
        ,t.first_payment_date
    FROM lns_loan_headers_all h, lns_terms t
   WHERE h.loan_id = p_loan_id AND
         h.loan_id = t.loan_id;

Line: 1184

    SELECT h.loan_term
        ,h.loan_term_period
        ,h.amortized_term
        ,h.amortized_term_period
        ,t.amortization_frequency
        ,t.loan_payment_frequency
    FROM lns_loan_headers_all h, lns_terms t
    WHERE h.loan_id = p_loan_id AND
         h.loan_id = t.loan_id;

Line: 1278

    SELECT decode(p_phase, 'OPEN', h.open_loan_term,
	                       'TERM', h.loan_term, h.loan_term)
        ,decode(p_phase, 'OPEN', h.open_loan_term_period,
				         'TERM', h.loan_term_period, h.loan_term_period)
        ,decode(p_phase, 'OPEN', t.open_payment_frequency,
				         'TERM', t.loan_payment_frequency, t.loan_payment_frequency)
        ,trunc(h.loan_start_date)
        ,trunc(t.first_payment_date)
        ,trunc(h.loan_maturity_date)
        ,decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')  -- calculate in advance or arrears
        ,nvl(t.PAYMENT_CALC_METHOD, 'EQUAL_PAYMENT')
        ,trunc(nvl(t.prin_first_pay_date, t.first_payment_date))
        ,nvl(t.prin_payment_frequency, t.loan_payment_frequency)
        ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y')
        ,nvl(h.custom_payments_flag, 'N')
    FROM lns_loan_headers_all h, lns_terms t
    WHERE h.loan_id = p_loan_id AND
         h.loan_id = t.loan_id;

Line: 1298

        select max(PAYMENT_NUMBER)
        from LNS_CUSTOM_PAYMNT_SCHEDS
        where loan_id = p_loan_id;

Line: 1554

     l_delete_tbl                number_tbl;

Line: 1703

                l_delete_tbl(j) := i+1;

Line: 1708

                l_delete_tbl(j) := i+1;

Line: 1714

        for i in 1..l_delete_tbl.count loop
          l_merged_payment_tbl.delete(l_delete_tbl(i));

Line: 1762

 select current_interest_rate
   from lns_rate_schedules rs
       ,lns_terms t
       ,lns_loan_headers_All lnh
  where lnh.loan_id = p_loan_id
    and lnh.loan_id = t.loan_id
    and t.term_id = rs.term_id
    and rs.end_installment_number >= p_last_installment
    and rs.begin_installment_number <= p_last_installment
    and rs.end_date_active is null
    and rs.phase = lnh.current_phase;

Line: 1826

    select interest_rate
      from lns_int_Rate_lines
     where interest_rate_id = p_index_rate_id
       and p_rate_date >= start_date_active
       and p_rate_date < end_date_active;