APPS.GL_FORMSINFO dependencies on GL_ACCESS_SET_LEDGERS

Line 154: FROM gl_access_set_ledgers

150: X_edate IN DATE) RETURN VARCHAR2 IS
151:
152: CURSOR check_access_ledger IS
153: SELECT access_privilege_code
154: FROM gl_access_set_ledgers
155: WHERE access_set_id = X_access_set_id
156: AND ledger_id = X_ledger_id
157: AND ( (X_edate IS NULL)
158: OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)

Line 252: FROM gl_access_set_ledgers asl

248: -- This cursor is used to find out if the default ledger specified in the
249: -- access set satisfies the access privilege and date requested.
250: CURSOR sdl IS
251: SELECT asl.ledger_id
252: FROM gl_access_set_ledgers asl
253: WHERE asl.access_set_id = X_access_set_id
254: AND asl.ledger_id = (select gas.default_ledger_id
255: from gl_access_sets gas
256: where gas.access_set_id = asl.access_set_id)

Line 268: FROM gl_access_set_ledgers

264: AND nvl(trunc(asl.end_date), trunc(X_edate)+1)));
265:
266: CURSOR gdl IS
267: SELECT distinct ledger_id
268: FROM gl_access_set_ledgers
269: WHERE access_set_id = X_access_set_id
270: AND ( ( (X_access_privilege_code = 'F')
271: AND (access_privilege_code = 'F'))
272: OR ( (X_access_privilege_code = 'B')

Line 330: FROM gl_access_set_ledgers

326:
327: FUNCTION has_single_ledger ( X_access_set_id IN NUMBER ) RETURN BOOLEAN IS
328: CURSOR ledger_curr IS
329: SELECT count(*)
330: FROM gl_access_set_ledgers
331: WHERE access_set_id = X_access_set_id
332: AND rownum < 3;
333:
334: ledger_count NUMBER;

Line 348: FROM gl_access_set_ledgers

344:
345: FUNCTION write_any_ledger ( X_access_set_id IN NUMBER ) RETURN BOOLEAN IS
346: CURSOR ledger_access_curr IS
347: SELECT nvl(max(1),0)
348: FROM gl_access_set_ledgers
349: WHERE access_set_id = X_access_set_id
350: AND access_privilege_code in ('W', 'F')
351: AND rownum < 2;
352: