eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_SYSOPS_BANK_PKG dependencies on GL_ACCESS_SETS

Line 605: from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas

601: IS
602: CURSOR CUR_DAS
603: IS
604: select segment_value
605: from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas
606: where gasn.access_set_id = gas.access_set_id
607: and SECURITY_SEGMENT_CODE = 'B'
608: and ALL_SEGMENT_VALUE_FLAG='N'
609: and gasn.access_set_id = p_das

Line 623: from GL_ACCESS_SETS gas

619: BEGIN
620: --Get the bsv flag of the das
621: select count(1)
622: into l_das_bsv
623: from GL_ACCESS_SETS gas
624: where SECURITY_SEGMENT_CODE = 'B'
625: and gas.access_set_id = p_das;
626:
627: --Enable Security rule

Line 665: from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas

661: BEGIN
662: --Get 'ALL' flag of bsv in the das
663: select ALL_SEGMENT_VALUE_FLAG
664: INTO l_bsv_all
665: from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas
666: where gasn.access_set_id = gas.access_set_id
667: and SECURITY_SEGMENT_CODE = 'B'
668: and ALL_SEGMENT_VALUE_FLAG = 'Y'
669: and gasn.access_set_id = p_das