DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on GL_LEDGERS_PUBLIC_V

Line 197: FROM gl_ledgers_public_v

193: AND enabled_flag ='Y';
194:
195: CURSOR c_ledger_exists (p_ledger_id IN NUMBER, p_ledger_name IN VARCHAR2) IS
196: SELECT 1
197: FROM gl_ledgers_public_v
198: WHERE ledger_id = p_ledger_id
199: AND name = p_ledger_name;
200:
201: CURSOR c_ledger_id_exists (p_ledger_id IN NUMBER) IS

Line 203: FROM gl_ledgers_public_v

199: AND name = p_ledger_name;
200:
201: CURSOR c_ledger_id_exists (p_ledger_id IN NUMBER) IS
202: SELECT 1
203: FROM gl_ledgers_public_v
204: WHERE ledger_id = p_ledger_id;
205:
206: CURSOR c_ledger_name_exists (p_ledger_name IN VARCHAR2) IS
207: SELECT ledger_id

Line 208: FROM gl_ledgers_public_v

204: WHERE ledger_id = p_ledger_id;
205:
206: CURSOR c_ledger_name_exists (p_ledger_name IN VARCHAR2) IS
207: SELECT ledger_id
208: FROM gl_ledgers_public_v
209: WHERE name = p_ledger_name;
210:
211: BEGIN
212:

Line 2855: FROM gl_ledgers_public_v

2851: WHERE organization_id = fnd_profile.value('DEFAULT_ORG_ID');
2852:
2853: CURSOR c_ledger_from_gl(cv_ledger_id IN NUMBER) IS
2854: SELECT COUNT(1)
2855: FROM gl_ledgers_public_v
2856: WHERE ledger_id = cv_ledger_id;
2857:
2858: CURSOR c_gl_ccid(cv_code_combi_id IN NUMBER)IS
2859: SELECT COUNT(1)