DBA Data[Home] [Help]

APPS.XLA_TP_BALANCE_RPT_PKG dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 509: l_ledger_set_from := l_ledger_set_from ||' ,gl_ledger_set_assignments glst ';

505: --
506: -- build join condition based on if ledger passed is a ledger set or a ledger
507: --
508: IF l_object_type = 'S' THEN
509: l_ledger_set_from := l_ledger_set_from ||' ,gl_ledger_set_assignments glst ';
510: l_ledger_set_where := l_ledger_set_where||' AND glst.ledger_set_id = :P_LEDGER_ID '||
511: ' AND gll.ledger_id = glst.ledger_id ';
512:
513: SELECT ledger_id

Line 515: FROM gl_ledger_set_assignments

511: ' AND gll.ledger_id = glst.ledger_id ';
512:
513: SELECT ledger_id
514: INTO l_ledger_id
515: FROM gl_ledger_set_assignments
516: WHERE ledger_set_id = p_ledger_id
517: AND ROWNUM = 1;
518: ELSE
519: l_ledger_set_where := l_ledger_set_where||' AND gll.ledger_id = :P_LEDGER_ID ';