APPS.XLA_TB_DATA_MANAGER_PVT dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 2240: ,gl_ledger_set_assignments sa

2236: IF p_object_type_code = 'S' THEN
2237: l_ledger_where := ' AND xah.ledger_id IN
2238: (SELECT gl.ledger_id
2239: FROM gl_ledgers gl
2240: ,gl_ledger_set_assignments sa
2241: WHERE gl.ledger_id = sa.ledger_id
2242: AND sa.ledger_set_id = :9) ';
2243: ELSE
2244: l_ledger_where := ' AND xah.ledger_id = :9 ';

Line 3095: -- use joins between gl_ledgers and gl_ledger_set_assignments

3091: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3092:
3093: --
3094: -- If object type is 'S' (Ledger Set) then
3095: -- use joins between gl_ledgers and gl_ledger_set_assignments
3096: -- else
3097: -- use a simple join with gl_ledgers
3098: -- end if
3099: l_ledger_where := get_ledger_where

Line 3601: -- use joins between gl_ledgers and gl_ledger_set_assignments

3597: END IF;
3598:
3599: --
3600: -- If object type is 'S' (Ledger Set) then
3601: -- use joins between gl_ledgers and gl_ledger_set_assignments
3602: -- else
3603: -- use a simple join with gl_ledgers
3604: -- end if
3605: l_ledger_where := get_ledger_where

Line 3965: ,gl_ledger_set_assignments sa

3961: WHERE group_id = p_group_id
3962: AND ledger_id IN (
3963: SELECT lg.ledger_id
3964: FROM gl_ledgers lg
3965: ,gl_ledger_set_assignments sa
3966: WHERE lg.ledger_id = sa.ledger_id
3967: AND sa.ledger_set_id = p_ledger_id)
3968: GROUP BY ae_header_id
3969: )

Line 4066: ,gl_ledger_set_assignments sa

4062: WHERE gl_transfer_status_code IN ('Y','NT')
4063: AND aeh.ledger_id IN (
4064: SELECT lg.ledger_id
4065: FROM gl_ledgers lg
4066: ,gl_ledger_set_assignments sa
4067: WHERE lg.ledger_id = sa.ledger_id
4068: AND sa.ledger_set_id = p_ledger_id)
4069: AND xtd.definition_code = p_definition_code
4070: AND xtd.definition_code = xjs.definition_code

Line 4172: ,gl_ledger_set_assignments sa

4168: WHERE gl_transfer_status_code IN ('Y','NT')
4169: AND aeh.ledger_id IN (
4170: SELECT lg.ledger_id
4171: FROM gl_ledgers lg
4172: ,gl_ledger_set_assignments sa
4173: WHERE lg.ledger_id = sa.ledger_id
4174: AND sa.ledger_set_id = p_ledger_id)
4175: AND xtd.definition_code = p_definition_code
4176: AND xtd.definition_code = xjs.definition_code