7729: ,nvl(t.CAPITALIZE_INT, 'N')
7730: ,nvl(t.FLUCTUATE_EQ_PAY_AMOUNT, 'N')
7731: FROM lns_loan_headers_all h
7732: ,lns_terms t
7733: ,fnd_currencies curr
7734: WHERE h.loan_id = p_loan_id
7735: AND t.loan_id = h.loan_id
7736: AND curr.currency_code = h.loan_currency;
7737:
10620:
10621: cursor c_curr_precision(p_loan_id number) is
10622: select curr.precision
10623: from lns_loan_headers_all h
10624: ,fnd_currencies curr
10625: where h.loan_id = p_loan_id
10626: and curr.currency_code = h.loan_currency;
10627:
10628: begin
11069:
11070: cursor c_curr_precision(p_loan_id number) is
11071: select curr.precision
11072: from lns_loan_headers_all h
11073: ,fnd_currencies curr
11074: where h.loan_id = p_loan_id
11075: and curr.currency_code = h.loan_currency;
11076:
11077: begin
11346:
11347: cursor c_curr_precision(p_loan_id number) is
11348: select curr.precision
11349: from lns_loan_headers_all h
11350: ,fnd_currencies curr
11351: where h.loan_id = p_loan_id
11352: and curr.currency_code = h.loan_currency;
11353:
11354: begin
12222:
12223: cursor c_curr_precision(p_loan_id number) is
12224: select curr.precision
12225: from lns_loan_headers_all h
12226: ,fnd_currencies curr
12227: where h.loan_id = p_loan_id
12228: and curr.currency_code = h.loan_currency;
12229:
12230: begin