430: AND fund_category like nvl(:cv_sf133_line_category, ' || '''' ||'%' || ''''||')';
431:
432: -- Data Access Security:
433: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
434: das_where := gl_access_set_security_pkg.get_security_clause
435: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
436: gl_access_set_security_pkg.CHECK_LEDGER_ID,
437: to_char(parm_set_of_books_id), null,
438: gl_access_set_security_pkg.CHECK_SEGVALS,
431:
432: -- Data Access Security:
433: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
434: das_where := gl_access_set_security_pkg.get_security_clause
435: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
436: gl_access_set_security_pkg.CHECK_LEDGER_ID,
437: to_char(parm_set_of_books_id), null,
438: gl_access_set_security_pkg.CHECK_SEGVALS,
439: null, 'glcc', null);
432: -- Data Access Security:
433: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
434: das_where := gl_access_set_security_pkg.get_security_clause
435: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
436: gl_access_set_security_pkg.CHECK_LEDGER_ID,
437: to_char(parm_set_of_books_id), null,
438: gl_access_set_security_pkg.CHECK_SEGVALS,
439: null, 'glcc', null);
440: IF (das_where IS NOT NULL) THEN
434: das_where := gl_access_set_security_pkg.get_security_clause
435: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
436: gl_access_set_security_pkg.CHECK_LEDGER_ID,
437: to_char(parm_set_of_books_id), null,
438: gl_access_set_security_pkg.CHECK_SEGVALS,
439: null, 'glcc', null);
440: IF (das_where IS NOT NULL) THEN
441: v_select := v_select || '
442: AND ' || das_where;