APPS.XLA_TB_DATA_MANAGER_PVT dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 2289: ,gl_ledger_set_assignments sa

2285: IF p_object_type_code = 'S' THEN
2286: l_ledger_where := ' AND xah.ledger_id IN
2287: (SELECT gl.ledger_id
2288: FROM gl_ledgers gl
2289: ,gl_ledger_set_assignments sa
2290: WHERE gl.ledger_id = sa.ledger_id
2291: AND sa.ledger_set_id = :9) ';
2292: ELSE
2293: l_ledger_where := ' AND xah.ledger_id = :9 ';

Line 3150: -- use joins between gl_ledgers and gl_ledger_set_assignments

3146: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3147:
3148: --
3149: -- If object type is 'S' (Ledger Set) then
3150: -- use joins between gl_ledgers and gl_ledger_set_assignments
3151: -- else
3152: -- use a simple join with gl_ledgers
3153: -- end if
3154: l_ledger_where := get_ledger_where

Line 3754: -- use joins between gl_ledgers and gl_ledger_set_assignments

3750: END IF;
3751:
3752: --
3753: -- If object type is 'S' (Ledger Set) then
3754: -- use joins between gl_ledgers and gl_ledger_set_assignments
3755: -- else
3756: -- use a simple join with gl_ledgers
3757: -- end if
3758: l_ledger_where := get_ledger_where

Line 4118: ,gl_ledger_set_assignments sa

4114: WHERE group_id = p_group_id
4115: AND ledger_id IN (
4116: SELECT lg.ledger_id
4117: FROM gl_ledgers lg
4118: ,gl_ledger_set_assignments sa
4119: WHERE lg.ledger_id = sa.ledger_id
4120: AND sa.ledger_set_id = p_ledger_id)
4121: GROUP BY ae_header_id
4122: )

Line 4219: ,gl_ledger_set_assignments sa

4215: WHERE gl_transfer_status_code IN ('Y','NT')
4216: AND aeh.ledger_id IN (
4217: SELECT lg.ledger_id
4218: FROM gl_ledgers lg
4219: ,gl_ledger_set_assignments sa
4220: WHERE lg.ledger_id = sa.ledger_id
4221: AND sa.ledger_set_id = p_ledger_id)
4222: AND xtd.definition_code = p_definition_code
4223: AND xtd.definition_code = xjs.definition_code

Line 4325: ,gl_ledger_set_assignments sa

4321: WHERE gl_transfer_status_code IN ('Y','NT')
4322: AND aeh.ledger_id IN (
4323: SELECT lg.ledger_id
4324: FROM gl_ledgers lg
4325: ,gl_ledger_set_assignments sa
4326: WHERE lg.ledger_id = sa.ledger_id
4327: AND sa.ledger_set_id = p_ledger_id)
4328: AND xtd.definition_code = p_definition_code
4329: AND xtd.definition_code = xjs.definition_code