APPS.XLA_ACCT_SETUP_PKG dependencies on GL_LEDGERS

Line 254: FROM xla_gl_ledgers_v

250: l_accounting_method_type VARCHAR2(80) := NULL;
251:
252: CURSOR c_ledger IS
253: SELECT chart_of_accounts_id, sla_accounting_method_code, sla_accounting_method_type
254: FROM xla_gl_ledgers_v
255: WHERE ledger_id = p_ledger_id;
256:
257: l_ledger c_ledger%rowtype;
258:

Line 269: FROM xla_gl_ledgers_v

265: l_trx_coa c_trx_coa%rowtype;
266:
267: CURSOR c_pr_ledger_coa IS
268: SELECT chart_of_accounts_id
269: FROM xla_gl_ledgers_v
270: WHERE ledger_id = p_primary_ledger_id;
271:
272: l_pr_ledger_coa c_pr_ledger_coa%rowtype;
273:

Line 628: ,gl_ledgers gll

624: FROM
625: xla_ledger_relationships_v xlr
626: ,xla_subledgers xsl
627: ,xla_acctg_methods_b xam
628: ,gl_ledgers gll
629: WHERE
630: xlr.ledger_category_code IN ('PRIMARY','SECONDARY')
631: AND xlr.sla_accounting_method_code IS NOT NULL
632: AND xsl.application_id = c1.application_id

Line 659: -- of column gl_ledgers.net_income_code_combination_id, which decides if

655: 'that are not already setup',20);
656:
657: -------------------------------------------------------------------------
658: -- The value of 'transfer_to_gl_mode_code' is decided based on the value
659: -- of column gl_ledgers.net_income_code_combination_id, which decides if
660: -- 'Daily Balances' are enabled for the ledger or not. (Bug 3128896).
661: -------------------------------------------------------------------------
662: INSERT INTO xla_ledger_options
663: (application_id

Line 700: ,gl_ledgers gll

696: FROM
697: xla_ledger_relationships_v xlr
698: ,xla_subledgers xsl
699: ,xla_acctg_methods_b xam
700: ,gl_ledgers gll
701: ,gl_ledgers gl2
702: WHERE
703: xlr.ledger_category_code IN ('PRIMARY','SECONDARY')
704: AND xlr.sla_accounting_method_code IS NOT NULL

Line 701: ,gl_ledgers gl2

697: xla_ledger_relationships_v xlr
698: ,xla_subledgers xsl
699: ,xla_acctg_methods_b xam
700: ,gl_ledgers gll
701: ,gl_ledgers gl2
702: WHERE
703: xlr.ledger_category_code IN ('PRIMARY','SECONDARY')
704: AND xlr.sla_accounting_method_code IS NOT NULL
705: AND xsl.application_id = c1.application_id

Line 754: ,gl_ledgers gll

750: FROM
751: xla_ledger_relationships_v xlr
752: ,xla_subledgers xsl
753: ,xla_acctg_methods_b xam
754: ,gl_ledgers gll
755: ,xla_event_class_attrs xec
756: WHERE
757: xlr.ledger_category_code IN ('PRIMARY','SECONDARY')
758: AND xlr.sla_accounting_method_code IS NOT NULL

Line 964: FROM gl_ledgers

960: -------------------------------------------------------------------------
961: IF g_transfer_to_gl_mode_code IS NULL THEN
962: SELECT decode(net_income_code_combination_id,NULL,'P','A')
963: INTO g_transfer_to_gl_mode_code
964: FROM gl_ledgers
965: WHERE ledger_id = p_ledger_id;
966: END IF;
967:
968: INSERT INTO xla_ledger_options

Line 1168: FROM xla_gl_ledgers_v

1164: l_currency_code VARCHAR2(15) := null;
1165:
1166: CURSOR c_ledger_currency(p_ledger_id IN NUMBER) IS
1167: SELECT currency_code
1168: FROM xla_gl_ledgers_v
1169: WHERE ledger_id = p_ledger_id;
1170:
1171: BEGIN
1172: trace('> xla_acct_setup_pkg.check_ledger_currency' , 10);

Line 1341: -- is determined based on gl_ledgers.net_income_code_combination_id in the

1337: g_processing_unit_size := 1000;
1338:
1339: ----------------------------------------------------------------------------
1340: -- g_transfer_to_gl_mode_code should be set to null here because its value
1341: -- is determined based on gl_ledgers.net_income_code_combination_id in the
1342: -- routine INSERT_LEDGER_OPTIONS.
1343: ----------------------------------------------------------------------------
1344: g_transfer_to_gl_mode_code := NULL;
1345: g_acct_reversal_option_code := 'SIDE';