DBA Data[Home] [Help]

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 751: FROM gl_ledgers_public_v

747:
748: CURSOR set_of_books is
749: SELECT chart_of_accounts_id,
750: currency_code
751: FROM gl_ledgers_public_v
752: WHERE ledger_id = g_ledger_id;
753:
754: others EXCEPTION;
755:

Line 5444: FROM gl_ledgers_public_v

5440: from dual;
5441:
5442: cursor enable_approval is
5443: SELECT enable_je_approval_flag
5444: FROM gl_ledgers_public_v
5445: WHERE ledger_id = g_ledger_id;
5446:
5447: cursor je_source(c_orig_batch_id IN NUMBER) is
5448: SELECT JH.je_source je_source