[Home] [Help]
480: ,NVL(P.BDGT_REQ_FOR_APPR_FLAG, 'N') BDGT_REQ_FOR_APPR_FLAG
481: ,NVL(P.LOAN_APPR_REQ_FLAG, 'Y') LOAN_APPR_REQ_FLAG
482: ,H.SECONDARY_STATUS
483: ,nvl(custom_payments_flag, 'N')
484: FROM LNS_LOAN_HEADERS_ALL H,
485: LNS_LOAN_PRODUCTS_ALL P
486: WHERE H.LOAN_ID = X_Loan_Id
487: and H.product_id = P.loan_product_id(+);
488:
523: -- getting loan previous secondary status to reset if Conversion request is rejected
524: CURSOR prev_sec_status_cur(P_LOAN_ID number) IS
525: select old_value
526: from lns_loan_histories_h
527: where table_name = 'LNS_LOAN_HEADERS_ALL' and
528: column_name = 'SECONDARY_STATUS' and
529: new_value = 'PENDING_CANCELLATION' and
530: loan_id = P_LOAN_ID and
531: loan_history_id =
530: loan_id = P_LOAN_ID and
531: loan_history_id =
532: (select max(loan_history_id)
533: from lns_loan_histories_h
534: where table_name = 'LNS_LOAN_HEADERS_ALL' and
535: column_name = 'SECONDARY_STATUS' and
536: loan_id = P_LOAN_ID);
537:
538: /* get statement after its billed */
552: AND dist.activity = 'LNS_APPROVAL';
553:
554: cursor c_get_bill_opt(p_loan_id number) is
555: select nvl(BILL_ON_APPR_AMOUNT_FLAG, 'N')
556: from lns_loan_headers_all
557: where loan_id = p_loan_id;
558:
559: cursor c_gl_date (p_loan_id number) is
560: select adj.gl_date
1647: nvl(loan.ADD_REQUESTED_AMOUNT, 0),
1648: loan.loan_status,
1649: loan.OBJECT_VERSION_NUMBER
1650: from lns_loan_lines line,
1651: lns_loan_headers_all loan
1652: where line.loan_line_id = P_LOAN_LINE_ID and
1653: line.loan_id = loan.loan_id;
1654:
1655: -- checking for conditions
1918: adj.DESCRIPTION,
1919: to_char(adj.ADJUSTMENT_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
1920: adj.EFFECTIVE_DATE
1921: from LNS_LOAN_AMOUNT_ADJS adj,
1922: lns_loan_headers_all loan
1923: where adj.LOAN_AMOUNT_ADJ_ID = P_LOAN_AMOUNT_ADJ_ID and
1924: adj.loan_id = loan.loan_id;
1925:
1926: -- checking for conditions