451: AND fscg.sf133_line_acct_id = acct.sf133_line_acct_id';
452:
453: -- Data Access Security:
454: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
455: das_where := gl_access_set_security_pkg.get_security_clause
456: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
457: gl_access_set_security_pkg.CHECK_LEDGER_ID,
458: to_char(parm_set_of_books_id), null,
459: gl_access_set_security_pkg.CHECK_SEGVALS,
452:
453: -- Data Access Security:
454: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
455: das_where := gl_access_set_security_pkg.get_security_clause
456: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
457: gl_access_set_security_pkg.CHECK_LEDGER_ID,
458: to_char(parm_set_of_books_id), null,
459: gl_access_set_security_pkg.CHECK_SEGVALS,
460: null, 'glcc', null);
453: -- Data Access Security:
454: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
455: das_where := gl_access_set_security_pkg.get_security_clause
456: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
457: gl_access_set_security_pkg.CHECK_LEDGER_ID,
458: to_char(parm_set_of_books_id), null,
459: gl_access_set_security_pkg.CHECK_SEGVALS,
460: null, 'glcc', null);
461: IF (das_where IS NOT NULL) THEN
455: das_where := gl_access_set_security_pkg.get_security_clause
456: (das_id, gl_access_set_security_pkg.READ_ONLY_ACCESS,
457: gl_access_set_security_pkg.CHECK_LEDGER_ID,
458: to_char(parm_set_of_books_id), null,
459: gl_access_set_security_pkg.CHECK_SEGVALS,
460: null, 'glcc', null);
461: IF (das_where IS NOT NULL) THEN
462: v_select := v_select || '
463: AND ' || das_where;