APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_LEDGERS

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

Line 7704: FROM gl_ledgers

7700: fnd_id_flex_segments
7701: WHERE
7702: id_flex_num = (SELECT
7703: chart_of_accounts_id
7704: FROM gl_ledgers
7705: WHERE ledger_id = p_ledger_id)
7706: AND id_flex_code = 'GL#'
7707: AND application_id = 101
7708: AND enabled_flag = 'Y';

Line 9524: FROM gl_ledgers

9520: GROUP BY ae_header_id;
9521:
9522: CURSOR get_ledger_category (p_ledgerid IN NUMBER) IS
9523: SELECT ledger_category_code
9524: FROM gl_ledgers
9525: WHERE ledger_id = p_ledgerid;
9526:
9527: CURSOR debug_xla_ae_headers_gt IS
9528: SELECT ae_header_id, ledger_id, entity_id, event_id,

Line 9826: l_ledger_category gl_ledgers.ledger_category_code%type;

9822: l_var_2 number;
9823: l_xla_hdr_status VARCHAR2(1);
9824: l_ae_lines_gt ae_lines_gt_rec;
9825: l_validation_lines_gt validation_lines_gt_rec;
9826: l_ledger_category gl_ledgers.ledger_category_code%type;
9827: l_event_cnt NUMBER;
9828: l_ae_event_cnt NUMBER;
9829:
9830: -- Allocation Attributes related variables