APPS.GL_FORMSINFO dependencies on GL_ACCESS_SET_ASSIGNMENTS

Line 163: FROM gl_access_set_assignments

159: AND nvl(trunc(end_date), trunc(X_edate)+1)));
160:
161: CURSOR check_access_segment IS
162: SELECT decode(max(decode(access_privilege_code, 'B', 2, 1)), 1, 'R', 2, 'B', 'N')
163: FROM gl_access_set_assignments
164: WHERE access_set_id = X_access_set_id
165: AND segment_value = X_segment_value
166: AND ( (X_edate IS NULL)
167: OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)

Line 172: FROM gl_access_set_assignments

168: AND nvl(trunc(end_date), trunc(X_edate)+1)));
169:
170: CURSOR check_access_ls IS
171: SELECT access_privilege_code
172: FROM gl_access_set_assignments
173: WHERE access_set_id = X_access_set_id
174: AND ledger_id = X_ledger_id
175: AND segment_value = X_segment_value
176: AND ( (X_edate IS NULL)