APPS.GL_FLEX_INSERT_PKG dependencies on GL_LEDGERS

Line 255: /* GL_LEDGERS */

251: /* */
252: /* GL Tables which are being used include : */
253: /* */
254: /* GL_CODE_COMBINATIONS */
255: /* GL_LEDGERS */
256: /* GL_BUDGET_ASSIGNMENT_RANGES */
257: /* GL_BUDGET_ASSIGNMENTS */
258: /* GL_SUMMARY_TEMPLATES */
259: /* GL_DYNAMIC_SUMM_COMBINATIONS */

Line 984: from gl_ledgers

980: l_defined BOOLEAN;
981:
982: cursor cnt_lgr(coaid NUMBER) IS
983: select count(*)
984: from gl_ledgers
985: where enable_budgetary_control_flag = 'Y'
986: and chart_of_accounts_id = coaid;
987:
988:

Line 1332: gl_ledgers lgr

1328: sysdate,
1329: user_id,
1330: login_id
1331: from gl_budget_assignment_ranges bar,
1332: gl_ledgers lgr
1333: where
1334: exists (select 'found' from gl_budorg_bc_options bco
1335: where bar.range_id = bco.range_id)
1336: AND (seg_val(1) IS NULL OR seg_val(1) BETWEEN bar.segment1_low AND

Line 1536: 'gl_ledgers lgr ' ||

1532: end loop;
1533:
1534: sql_stmp := sql_stmp || ' ' ||
1535: 'from gl_summary_templates smt, ' ||
1536: 'gl_ledgers lgr ' ||
1537: 'where smt.status in (''A'', ''F'') ' ||
1538: 'and smt.account_category_code = :catg ' ||
1539: 'and smt.ledger_id = lgr.ledger_id ' ||
1540: 'and lgr.enable_budgetary_control_flag = ''Y'' ' ||