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 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

Line 7890: FROM gl_ledgers

7886: fnd_id_flex_segments
7887: WHERE
7888: id_flex_num = (SELECT
7889: chart_of_accounts_id
7890: FROM gl_ledgers
7891: WHERE ledger_id = p_ledger_id)
7892: AND id_flex_code = 'GL#'
7893: AND application_id = 101
7894: AND enabled_flag = 'Y';

Line 9795: FROM gl_ledgers

9791: GROUP BY ae_header_id;
9792:
9793: CURSOR get_ledger_category (p_ledgerid IN NUMBER) IS
9794: SELECT ledger_category_code
9795: FROM gl_ledgers
9796: WHERE ledger_id = p_ledgerid;
9797:
9798: CURSOR debug_xla_ae_headers_gt IS
9799: SELECT ae_header_id, ledger_id, entity_id, event_id,

Line 10101: l_ledger_category gl_ledgers.ledger_category_code%type;

10097: l_var_2 number;
10098: l_xla_hdr_status VARCHAR2(1);
10099: l_ae_lines_gt ae_lines_gt_rec;
10100: l_validation_lines_gt validation_lines_gt_rec;
10101: l_ledger_category gl_ledgers.ledger_category_code%type;
10102: l_event_cnt NUMBER;
10103: l_ae_event_cnt NUMBER;
10104:
10105: -- Allocation Attributes related variables