APPS.CST_REVENUECOGSMATCH_PVT dependencies on GL_SETS_OF_BOOKS

Line 1555: FROM gl_sets_of_books

1551: -- Add cursor for ledger access
1552: CURSOR cu_ledger(p_ledger_id IN NUMBER)
1553: IS
1554: SELECT DISTINCT set_of_books_id
1555: FROM gl_sets_of_books
1556: WHERE set_of_books_id = NVL(p_ledger_id,set_of_books_id);
1557:
1558:
1559: -- CRRL.last_event_date corresponds to the Revenue Recognition date that AR pass to CST.

Line 4222: gl_sets_of_books sob,

4218: NVL(mmt.transaction_source_id, -1)
4219: FROM cst_cogs_events cce,
4220: cst_revenue_cogs_match_lines crcml,
4221: mtl_parameters mp,
4222: gl_sets_of_books sob,
4223: mtl_material_transactions mmt -- joining here to use the index on costed_flag
4224: WHERE
4225: cce.mmt_transaction_id = mmt.transaction_id
4226: AND mmt.costed_flag = 'N'

Line 4259: FROM gl_sets_of_books

4255:
4256: --{BUG#5726230
4257: CURSOR cu_ledger(p_ledger_id IN NUMBER) IS
4258: SELECT DISTINCT set_of_books_id
4259: FROM gl_sets_of_books
4260: WHERE set_of_books_id = NVL(p_ledger_id, set_of_books_id);
4261:
4262: l_ledger_id_tab number_table;
4263: l_sob NUMBER;

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

4320: RAISE end_of_program;
4321: END IF;
4322:
4323: <>
4324: -- FOR l_sob_id IN (SELECT distinct set_of_books_id FROM gl_sets_of_books) LOOP
4325: FOR i IN l_ledger_id_tab.FIRST .. l_ledger_id_tab.LAST LOOP
4326: --}
4327: l_sob := l_ledger_id_tab(i);
4328: debug(' processing for the ledger:'||l_sob);

Line 5773: gl_sets_of_books gsb,

5769: :i_sales_order_date_high sales_order_date_to,
5770: fl.meaning all_lines,
5771: :i_amt_tolerance tolerance_amount
5772: from hr_all_organization_units haou,
5773: gl_sets_of_books gsb,
5774: fnd_lookups fl
5775: where haou.organization_id = :i_operating_unit
5776: and gsb.set_of_books_id = :i_ledger_id
5777: and fl.lookup_code = :i_all_lines