[Home] [Help]
1914: ,sb.currency_code
1915: ,fndc.precision
1916: FROM lns_system_options so,
1917: gl_ledgers sb,
1918: fnd_currencies fndc
1919: WHERE sb.ledger_id = so.set_of_books_id
1920: and sb.currency_code = fndc.currency_code;
1921:
1922: l_ledger_details lns_distributions_pub.gl_ledger_details;
1999: cursor c_get_distribution(p_distribution_id number) is
2000: select round(lnh.funded_amount * lnd.distribution_percent / 100, curr.precision)
2001: from lns_distributions lnd
2002: ,lns_loan_headers lnh
2003: ,fnd_currencies curr
2004: where lnh.loan_id = lnd.loan_id
2005: and curr.currency_code = lnh.loan_currency
2006: and lnd.distribution_id = p_distribution_id;
2007:
2031: and account_type = p_account_type
2032: and loan_id = p_loan_id), curr.precision))
2033: from lns_distributions lnd
2034: ,lns_loan_headers lnh
2035: ,fnd_currencies curr
2036: where lnh.loan_id = lnd.loan_id
2037: and lnh.loan_id = p_loan_id
2038: and curr.currency_code = lnh.loan_currency;
2039:
2150: cursor c_get_distribution(p_distribution_id number) is
2151: select round(lnh.funded_amount * lnd.distribution_percent / 100, curr.precision)
2152: from lns_distributions lnd
2153: ,lns_loan_headers lnh
2154: ,fnd_currencies curr
2155: where lnh.loan_id = lnd.loan_id
2156: and curr.currency_code = lnh.loan_currency
2157: and lnd.distribution_id = p_distribution_id;
2158:
2170: and account_type = p_account_type
2171: and loan_id = p_loan_id), curr.precision))
2172: from lns_distributions lnd
2173: ,lns_loan_headers lnh
2174: ,fnd_currencies curr
2175: where lnh.loan_id = lnd.loan_id
2176: and lnh.loan_id = p_loan_id
2177: and curr.currency_code = lnh.loan_currency;
2178: