[Home] [Help]
2519: ,sb.period_set_name
2520: ,sb.currency_code
2521: ,fndc.precision
2522: FROM lns_system_options so,
2523: gl_ledgers sb,
2524: fnd_currencies fndc
2525: WHERE sb.ledger_id = so.set_of_books_id
2526: and sb.currency_code = fndc.currency_code;
2527:
2922: FROM fnd_id_flex_segments s
2923: , fnd_segment_attribute_values sav
2924: , fnd_segment_attribute_types sat
2925: , lns_system_options lso
2926: , gl_ledgers gl
2927: WHERE s.application_id = p_application_id
2928: and lso.set_of_books_id = gl.ledger_id
2929: AND s.id_flex_code = p_flex_code
2930: AND s.id_flex_num = gl.chart_of_accounts_id
2991: FROM fnd_id_flex_segments s
2992: ,fnd_segment_attribute_values sav
2993: ,fnd_segment_attribute_types sat
2994: ,lns_system_options lso
2995: ,gl_ledgers gl
2996: WHERE s.application_id = 101
2997: and lso.set_of_books_id = gl.ledger_id
2998: AND s.id_flex_code = 'GL#'
2999: AND s.id_flex_num = gl.chart_of_accounts_id
7957:
7958: /* query for ledger name */
7959: CURSOR cur_ledger(C_LEDGER_ID number) IS
7960: select name
7961: from gl_ledgers
7962: where ledger_id = C_LEDGER_ID;
7963:
7964: BEGIN
7965:
9038: CURSOR loan_cur(C_LOAN_ID number) IS
9039: SELECT
9040: loan.loan_number, nvl(loan.disable_int_accrual_flag, 'N'), ou.name, gl.name
9041: FROM
9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl
9043: WHERE loan.loan_id = C_LOAN_ID
9044: AND loan.org_id = lsysopt.org_id
9045: AND lsysopt.set_of_books_id = gl.ledger_id
9046: AND loan.org_id = ou.organization_id;
9086: CURSOR c_get_chart_acc_id(c_loan_id NUMBER) is
9087: SELECT sb.chart_of_accounts_id
9088: FROM lns_loan_headers lhdr,
9089: lns_system_options so,
9090: gl_ledgers sb,
9091: fnd_currencies fndc
9092: WHERE lhdr.loan_id = c_loan_id
9093: AND lhdr.org_id = so.org_id
9094: AND sb.ledger_id = so.set_of_books_id