APPS.CST_REVENUECOGSMATCH_PVT dependencies on GL_SETS_OF_BOOKS

Line 1374: FROM gl_sets_of_books

1370: -- Add cursor for ledger access
1371: CURSOR cu_ledger(p_ledger_id IN NUMBER)
1372: IS
1373: SELECT DISTINCT set_of_books_id
1374: FROM gl_sets_of_books
1375: WHERE set_of_books_id = NVL(p_ledger_id,set_of_books_id);
1376:
1377:
1378: -- CRRL.last_event_date corresponds to the Revenue Recognition date that AR pass to CST.

Line 1725: -- FROM gl_sets_of_books) LOOP

1721: END IF;
1722:
1723: <> -- for each ledger defined in the instance
1724: --FOR l_sob IN (SELECT distinct set_of_books_id
1725: -- FROM gl_sets_of_books) LOOP
1726: FOR i IN l_ledger_id_tab.FIRST .. l_ledger_id_tab.LAST LOOP
1727: --}
1728: l_sob := l_ledger_id_tab(i);
1729: debug(' processing for the ledger_id :'||l_sob);

Line 4158: gl_sets_of_books sob,

4154: NVL(mmt.transaction_source_id, -1)
4155: FROM cst_cogs_events cce,
4156: cst_revenue_cogs_match_lines crcml,
4157: mtl_parameters mp,
4158: gl_sets_of_books sob,
4159: mtl_material_transactions mmt -- joining here to use the index on costed_flag
4160: WHERE
4161: cce.mmt_transaction_id = mmt.transaction_id
4162: AND mmt.costed_flag = 'N'

Line 4195: FROM gl_sets_of_books

4191:
4192: --{BUG#5726230
4193: CURSOR cu_ledger(p_ledger_id IN NUMBER) IS
4194: SELECT DISTINCT set_of_books_id
4195: FROM gl_sets_of_books
4196: WHERE set_of_books_id = NVL(p_ledger_id, set_of_books_id);
4197:
4198: l_ledger_id_tab number_table;
4199: l_sob NUMBER;

Line 4260: -- FOR l_sob_id IN (SELECT distinct set_of_books_id FROM gl_sets_of_books) LOOP

4256: RAISE end_of_program;
4257: END IF;
4258:
4259: <>
4260: -- FOR l_sob_id IN (SELECT distinct set_of_books_id FROM gl_sets_of_books) LOOP
4261: FOR i IN l_ledger_id_tab.FIRST .. l_ledger_id_tab.LAST LOOP
4262: --}
4263: l_sob := l_ledger_id_tab(i);
4264: debug(' processing for the ledger:'||l_sob);

Line 5657: gl_sets_of_books gsb,

5653: :i_sales_order_date_low sales_order_date_from,
5654: :i_sales_order_date_high sales_order_date_to,
5655: fl.meaning all_lines
5656: from hr_all_organization_units haou,
5657: gl_sets_of_books gsb,
5658: fnd_lookups fl
5659: where haou.organization_id = :i_operating_unit
5660: and gsb.set_of_books_id = :i_ledger_id
5661: and fl.lookup_code = :i_all_lines