APPS.WIP_BIS_UTZ_ALERT dependencies on GL_SETS_OF_BOOKS

Line 312: FROM gl_sets_of_books

308: l_org_level := 'SET OF BOOKS';
309: END IF;
310: IF(org_level >= 1) THEN
311: SELECT MAX(set_of_books_id) INTO l_sob_id
312: FROM gl_sets_of_books
313: WHERE name = sob;
314: END IF;
315: IF(org_level = 2) /* LE */ THEN
316: l_org_level := 'LEGAL ENTITY';

Line 590: ' from gl_periods p, gl_sets_of_books sob ' ||

586: p_where_trgt_time := 'and gl_p.period_set_name = TEMP.period_set_name ' || -- Bug 3554853
587: 'and gl_p.period_name = TEMP.period_month ' || -- Bug 3554853
588: 'and gl_p.start_date = ' || -- Bug 3554853
589: ' (select max(gl_p.start_date) ' || -- Bug 3554853
590: ' from gl_periods p, gl_sets_of_books sob ' ||
591: ' where p.period_set_name = TEMP.period_set_name ' ||
592: ' and sob.SET_OF_BOOKS_ID = TEMP.set_of_books_id ' ||
593: ' and p.period_type = sob.ACCOUNTED_PERIOD_TYPE) ';
594: end if;