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

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

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

    select nvl(CURRENT_PHASE, 'TERM')
    from lns_loan_headers_all
    where loan_id = p_loan_id;

Line: 1387

    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)
        ,decode(p_phase, 'TERM', trunc(h.loan_start_date),
                         'OPEN' , trunc(h.open_loan_start_date), trunc(h.loan_start_date))
        ,decode(p_phase, 'TERM', trunc(t.first_payment_date),
                         'OPEN' , trunc(t.open_first_payment_date), trunc(t.first_payment_date))
        ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date),
                         'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date))
        ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
				       , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')
                       , decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y'))
        ,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: 1412

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

Line: 1762

     l_delete_tbl                number_tbl;

Line: 1911

                l_delete_tbl(j) := i+1;

Line: 1916

                l_delete_tbl(j) := i+1;

Line: 1922

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

Line: 1965

     l_delete_tbl                number_tbl;

Line: 2121

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

    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;

Line: 2253

    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)
        ,decode(p_phase, 'TERM', trunc(h.loan_start_date),
                         'OPEN' , trunc(h.open_loan_start_date), trunc(h.loan_start_date))
        ,decode(p_phase, 'TERM', trunc(t.first_payment_date),
                         'OPEN' , trunc(t.open_first_payment_date), trunc(t.first_payment_date))
        ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date),
                         'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date))
        ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
				       , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')
                       , decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y'))
        ,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: 2410

    SELECT decode(p_phase, 'TERM', trunc(h.loan_start_date),
                         'OPEN' , trunc(h.open_loan_start_date), trunc(h.loan_start_date))
        ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date),
                         'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date))
        ,nvl(t.PAYMENT_CALC_METHOD, 'EQUAL_PAYMENT')
        ,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: 2421

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

Line: 2605

    SELECT dh.loan_id
	  ,payment_request_date
	  ,(select max(disbursement_date) from lns_disb_lines
		 where disb_header_id = c_disb_hdr_id) disbursement_date
	  ,dh.phase
    FROM lns_disb_headers dh, lns_loan_headers_all lhdr
    WHERE dh.disb_header_id = c_disb_hdr_id
       AND lhdr.loan_id = dh.loan_id;

Line: 2874

    select FREQUENCY_BEGIN_DATE, FREQUENCY
    from LNS_FREQ_SCHEDULES
    where loan_id = p_loan_id and
    nvl(phase, 'TERM') = nvl(p_phase, 'TERM') and
    nvl(component, 'PRIN_INT') = nvl(p_component, 'PRIN_INT')
    order by FREQUENCY_BEGIN_DATE;