APPS.GL_MOVEMERGE_REQUESTS_PKG dependencies on GL_LEDGERS

Line 203: FROM gl_ledgers lgr, gl_ledger_relationships rel, gl_ledgers alc

199: target_ledger_name VARCHAR2(30);
200:
201: CURSOR ledger_id_cur IS
202: SELECT rel.target_ledger_name
203: FROM gl_ledgers lgr, gl_ledger_relationships rel, gl_ledgers alc
204: WHERE lgr.ledger_id = ledgerid
205: AND rel.source_ledger_id = lgr.ledger_id
206: AND rel.target_ledger_category_code = 'ALC'
207: AND rel.relationship_type_code <> 'BALANCE'

Line 238: object_type gl_ledgers.object_type_code%TYPE;

234:
235: PROCEDURE get_mm_ledger_id (ledgerid IN NUMBER,
236: mm_ledger_id IN OUT NOCOPY NUMBER)
237: IS
238: object_type gl_ledgers.object_type_code%TYPE;
239: CURSOR ledger_type IS
240: SELECT object_type_code
241: FROM gl_ledgers led
242: WHERE led.ledger_id = ledgerid;

Line 241: FROM gl_ledgers led

237: IS
238: object_type gl_ledgers.object_type_code%TYPE;
239: CURSOR ledger_type IS
240: SELECT object_type_code
241: FROM gl_ledgers led
242: WHERE led.ledger_id = ledgerid;
243:
244: CURSOR ledger_id_cursor IS
245: SELECT ledger_id