APPS.GL_FC_XLATE_PKG dependencies on GL_LEDGERS

Line 147: from gl_ledgers l, gl_ledger_set_assignments lsa

143: tcurr_code IN VARCHAR2) RETURN VARCHAR2 IS
144: dummy NUMBER;
145: CURSOR relation IS
146: select l.ledger_id
147: from gl_ledgers l, gl_ledger_set_assignments lsa
148: where lsa.ledger_set_id = ldg_id
149: and l.ledger_id = lsa.ledger_id
150: and l.object_type_code = 'L'
151: and l.ledger_category_code in ('PRIMARY','SECONDARY')

Line 184: from gl_ledgers l, gl_ledger_set_assignments lsa

180: bal_seg_val IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
181: dummy NUMBER;
182: CURSOR spec_bal IS
183: select l.ledger_id
184: from gl_ledgers l, gl_ledger_set_assignments lsa
185: where lsa.ledger_set_id = ldg_id
186: and l.ledger_id = lsa.ledger_id
187: and l.object_type_code = 'L'
188: and not exists

Line 197: from gl_ledgers l, gl_ledger_set_assignments lsa

193: and tt.bal_seg_value = bal_seg_val);
194:
195: CURSOR all_bal IS
196: select l.ledger_id
197: from gl_ledgers l, gl_ledger_set_assignments lsa
198: where lsa.ledger_set_id = ldg_id
199: and l.ledger_id = lsa.ledger_id
200: and l.object_type_code = 'L'
201: and not exists

Line 265: FROM gl_ledgers gll

261: gll.object_type_code
262: INTO l_period_set_name,
263: l_period_type,
264: l_object_type_code
265: FROM gl_ledgers gll
266: WHERE ledger_id = x_ledger_id;
267:
268: IF (l_object_type_code = 'S') THEN
269:

Line 273: GL_LEDGERS l

269:
270: SELECT glsa.ledger_id
271: INTO l_ledger_id
272: FROM GL_LEDGER_SET_ASSIGNMENTS glsa,
273: GL_LEDGERS l
274: WHERE glsa.ledger_set_id = x_ledger_id
275: AND glsa.ledger_id = l.ledger_id
276: AND l.object_type_Code = 'L'
277: AND ROWNUM = 1;