APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on GL_LEDGERS

Line 845: FROM gl_ledgers ledg -- (1)

841: FROM (SELECT acd.product_rule_type_code
842: , acd.product_rule_code
843: , sum(1) over (partition by subl.application_id) aad_count
844: -- FROM xla_subledger_options_v xso -- 5095554
845: FROM gl_ledgers ledg -- (1)
846: , gl_ledger_relationships glr -- (2)
847: , xla_ledger_options lopt -- (4)
848: , xla_subledgers subl -- (5)
849: -- , xla_acctg_methods_b acm

Line 851: , gl_ledgers led

847: , xla_ledger_options lopt -- (4)
848: , xla_subledgers subl -- (5)
849: -- , xla_acctg_methods_b acm
850: , xla_acctg_method_rules acd
851: , gl_ledgers led
852: WHERE subl.application_id = p_application_id
853: --
854: AND ledg.ledger_id = glr.target_ledger_id
855: AND ledg.ledger_id = lopt.ledger_id

Line 1390: FROM gl_ledgers glg

1386: SET xe.event_status_code = 'N'
1387: ,xe.process_status_code = 'P'
1388: ,xe.reference_char_4 = (CASE WHEN xe.application_id > 20000 then xe.reference_char_4 else 'CASH' end)
1389: WHERE EXISTS (SELECT 1
1390: FROM gl_ledgers glg
1391: ,xla_acctg_methods_b xam
1392: ,xla_acctg_method_rules xamr
1393: ,xla_prod_acct_headers xpah
1394: ,xla_event_types_b xetb

Line 1561: FROM gl_ledgers

1557: -- 6509160 Process non bc AAd package for Secondary non bc enabled ledger
1558: -- get category code of ledger
1559: SELECT ledger_category_code,enable_budgetary_control_flag
1560: INTO l_ledger_category_code,l_enable_bc_flag
1561: FROM gl_ledgers
1562: WHERE ledger_id = p_base_ledger_id;
1563: IF l_ledger_category_code='SECONDARY' and l_enable_bc_flag='N' THEN
1564: /* commented for bug-9245677 */
1565: /* l_statement := 'BEGIN :1 := '||p_pad_package ||'.CreateJournalEntries(:2,:3,:4,:5,:6 ); END;'; */

Line 1829: FROM gl_ledgers

1825:
1826: -- bug 6414911 For applications where AAd is not defined for secondary ledger,it implies product teams do not want to account for secondary ledger during funds reserve/check,hence dont stamp the budgetary event with error status.
1827: SELECT ledger_category_code,enable_budgetary_control_flag
1828: INTO l_ledger_category_code,l_enable_bc_flag
1829: FROM gl_ledgers
1830: WHERE ledger_id = l_array_base_ledgers(Jdx);
1831:
1832: IF nvl(p_budgetary_control_mode,'NONE')<>'NONE' and l_ledger_category_code ='SECONDARY' and l_enable_bc_flag='N' THEN
1833: IF (C_LEVEL_STATEMENT >= g_log_level) THEN