DBA Data[Home] [Help]

APPS.XLA_ACCT_SETUP_PKG dependencies on XLA_LEDGER_RELATIONSHIPS_V

Line 420: FROM xla_ledger_relationships_v xlr

416: CURSOR csr_ledgers IS
417: SELECT xlr.ledger_id ledger_id
418: ,xlr.primary_ledger_id primary_ledger_id
419: ,DECODE(xlo.ledger_id,NULL,'N','Y') ledger_setup_flag
420: FROM xla_ledger_relationships_v xlr
421: ,xla_ledger_options xlo
422: WHERE xlr.ledger_category_code IN ('PRIMARY','SECONDARY')
423: AND xlr.sla_accounting_method_code IS NOT NULL
424: AND xlo.application_id(+) = p_application_id

Line 625: xla_ledger_relationships_v xlr

621: ,l_sysdate
622: ,xla_environment_pkg.g_usr_id
623: ,xla_environment_pkg.g_login_id
624: FROM
625: xla_ledger_relationships_v xlr
626: ,xla_subledgers xsl
627: ,xla_acctg_methods_b xam
628: ,gl_ledgers gll
629: WHERE

Line 697: xla_ledger_relationships_v xlr

693: ,xla_environment_pkg.g_usr_id
694: ,xla_environment_pkg.g_login_id
695: --,'NONE'
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

Line 751: xla_ledger_relationships_v xlr

747: ,l_sysdate
748: ,xla_environment_pkg.g_usr_id
749: ,xla_environment_pkg.g_login_id
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