APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 135: g_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

131: g_override_flag BOOLEAN;
132:
133: g_bc_option_id gl_bc_options.bc_option_id%TYPE;
134:
135: g_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
136:
137: g_func_curr_code gl_ledgers_public_v.currency_code%TYPE;
138:
139: g_append_je_flag BOOLEAN;

Line 137: g_func_curr_code gl_ledgers_public_v.currency_code%TYPE;

133: g_bc_option_id gl_bc_options.bc_option_id%TYPE;
134:
135: g_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
136:
137: g_func_curr_code gl_ledgers_public_v.currency_code%TYPE;
138:
139: g_append_je_flag BOOLEAN;
140:
141: g_summarized_flag BOOLEAN;

Line 762: FROM gl_ledgers_public_v

758:
759: CURSOR set_of_books is
760: SELECT chart_of_accounts_id,
761: currency_code
762: FROM gl_ledgers_public_v
763: WHERE ledger_id = g_ledger_id;
764:
765: others EXCEPTION;
766:

Line 5519: FROM gl_ledgers_public_v

5515: from dual;
5516:
5517: cursor enable_approval is
5518: SELECT enable_je_approval_flag
5519: FROM gl_ledgers_public_v
5520: WHERE ledger_id = g_ledger_id;
5521:
5522: cursor je_source(c_orig_batch_id IN NUMBER) is
5523: SELECT JH.je_source je_source