APPS.GL_LEDGERS_PKG dependencies on GL_LEDGERS_S

Line 1532: FROM gl_ledgers srclg

1528: srclg.attribute12,
1529: srclg.attribute13,
1530: srclg.attribute14,
1531: srclg.attribute15
1532: FROM gl_ledgers srclg
1533: WHERE ledger_id = x_ledger_id)
1534: WHERE ledger_id IN(
1535: SELECT target_ledger_id
1536: FROM gl_ledger_relationships

Line 1772: SELECT gl_ledgers_s.NEXTVAL

1768: -- **********************************************************************
1769: FUNCTION get_unique_id
1770: RETURN NUMBER IS
1771: CURSOR c_getid IS
1772: SELECT gl_ledgers_s.NEXTVAL
1773: FROM DUAL;
1774:
1775: ID NUMBER;
1776: BEGIN

Line 1790: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');

1786: ELSE
1787: CLOSE c_getid;
1788:
1789: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
1790: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');
1791: app_exception.raise_exception;
1792: END IF;
1793: EXCEPTION
1794: WHEN app_exceptions.application_exception THEN

Line 3878: where GL_LEDGERS.SHORT_NAME = x_ledger_short_name

3874: x_dupl_flag OUT NOCOPY VARCHAR2) IS
3875: CURSOR get_duplicate IS
3876: select 'Duplicate'
3877: from GL_LEDGERS GL_LEDGERS
3878: where GL_LEDGERS.SHORT_NAME = x_ledger_short_name
3879: and GL_LEDGERS.LEDGER_ID <> x_ledger_id
3880: UNION
3881: select 'Duplicate'
3882: from GL_LEDGER_RELATIONSHIPS