APPS.XLA_TP_BALANCE_RPT_PKG dependencies on GL_LEDGER_SET_ASSIGNMENTS

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

534: --
535: -- build join condition based on if ledger passed is a ledger set or a ledger
536: --
537: IF l_object_type = 'S' THEN
538: l_ledger_set_from := l_ledger_set_from ||' ,gl_ledger_set_assignments glst ';
539: l_ledger_set_where := l_ledger_set_where||' AND glst.ledger_set_id = :P_LEDGER_ID '||
540: ' AND gll.ledger_id = glst.ledger_id ';
541:
542: SELECT ledger_id

Line 544: FROM gl_ledger_set_assignments

540: ' AND gll.ledger_id = glst.ledger_id ';
541:
542: SELECT ledger_id
543: INTO l_ledger_id
544: FROM gl_ledger_set_assignments
545: WHERE ledger_set_id = p_ledger_id
546: AND ROWNUM = 1;
547: ELSE
548: l_ledger_set_where := l_ledger_set_where||' AND gll.ledger_id = :P_LEDGER_ID ';