DBA Data[Home] [Help]

APPS.GL_SEL_SEG_TURNOVER_RPT_PKG dependencies on GL_LEDGERS

Line 15: FROM gl_ledgers gl1

11: ln_single_ledger_id NUMBER;
12: BEGIN
13: SELECT gl1.object_type_code
14: INTO lc_ledger_obj_type
15: FROM gl_ledgers gl1
16: WHERE gl1.ledger_id = p_ledger_id;
17:
18: IF (lc_ledger_obj_type = 'L') THEN
19: ln_single_ledger_id := p_ledger_id;

Line 24: ,gl_ledgers gl1

20: ELSE
21: SELECT gl1.ledger_id
22: INTO ln_single_ledger_id
23: FROM gl_ledger_set_assignments glsa
24: ,gl_ledgers gl1
25: WHERE glsa.ledger_set_id = p_ledger_id
26: AND gl1.ledger_id = glsa.ledger_id
27: AND gl1.object_type_code = 'L'
28: AND ROWNUM = 1;