DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on GL_LEDGERS

Line 839: FROM gl_ledgers ledg -- (1)

835: FROM (SELECT acd.product_rule_type_code
836: , acd.product_rule_code
837: , sum(1) over (partition by subl.application_id) aad_count
838: -- FROM xla_subledger_options_v xso -- 5095554
839: FROM gl_ledgers ledg -- (1)
840: , gl_ledger_relationships glr -- (2)
841: , xla_ledger_options lopt -- (4)
842: , xla_subledgers subl -- (5)
843: -- , xla_acctg_methods_b acm

Line 845: , gl_ledgers led

841: , xla_ledger_options lopt -- (4)
842: , xla_subledgers subl -- (5)
843: -- , xla_acctg_methods_b acm
844: , xla_acctg_method_rules acd
845: , gl_ledgers led
846: WHERE subl.application_id = p_application_id
847: --
848: AND ledg.ledger_id = glr.target_ledger_id
849: AND ledg.ledger_id = lopt.ledger_id

Line 1454: FROM gl_ledgers

1450: -- 6509160 Process non bc AAd package for Secondary non bc enabled ledger
1451: -- get category code of ledger
1452: SELECT ledger_category_code,enable_budgetary_control_flag
1453: INTO l_ledger_category_code,l_enable_bc_flag
1454: FROM gl_ledgers
1455: WHERE ledger_id = p_base_ledger_id;
1456: IF l_ledger_category_code='SECONDARY' and l_enable_bc_flag='N' THEN
1457: l_statement := 'BEGIN :1 := '||p_pad_package ||'.CreateJournalEntries(:2,:3,:4,:5,:6 ); END;';
1458: ELSE

Line 1710: FROM gl_ledgers

1706:
1707: -- 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.
1708: SELECT ledger_category_code,enable_budgetary_control_flag
1709: INTO l_ledger_category_code,l_enable_bc_flag
1710: FROM gl_ledgers
1711: WHERE ledger_id = l_array_base_ledgers(Jdx);
1712:
1713: IF nvl(p_budgetary_control_mode,'NONE')<>'NONE' and l_ledger_category_code ='SECONDARY' and l_enable_bc_flag='N' THEN
1714: IF (C_LEVEL_STATEMENT >= g_log_level) THEN