405: --
406: -- build join condition based on if ledger passed is a ledger set or a ledger
407: --
408: IF l_object_type = 'S' THEN
409: l_ledger_set_from := l_ledger_set_from ||' ,gl_ledger_set_assignments glst ';
410: l_ledger_set_where := l_ledger_set_where||' AND glst.ledger_set_id = :P_LEDGER_ID '||
411: ' AND gll.ledger_id = glst.ledger_id ';
412:
413: SELECT ledger_id
411: ' AND gll.ledger_id = glst.ledger_id ';
412:
413: SELECT ledger_id
414: INTO l_ledger_id
415: FROM gl_ledger_set_assignments
416: WHERE ledger_set_id = p_ledger_id
417: AND ROWNUM = 1;
418: ELSE
419: l_ledger_set_where := l_ledger_set_where||' AND gll.ledger_id = :P_LEDGER_ID ';