DBA Data[Home] [Help]

APPS.GL_ALLOC_FORM_LINES_PKG dependencies on GL_LEDGERS

Line 117: FROM gl_ledgers

113: x_ledger_currency VARCHAR2,
114: x_actual_flag VARCHAR2) IS
115: CURSOR ledger_object_type IS
116: SELECT object_type_code, currency_code
117: FROM gl_ledgers
118: WHERE ledger_id = x_ledger_id;
119:
120: CURSOR mismatch_curr IS
121: SELECT 'different currency'

Line 122: FROM gl_ledgers ldg,

118: WHERE ledger_id = x_ledger_id;
119:
120: CURSOR mismatch_curr IS
121: SELECT 'different currency'
122: FROM gl_ledgers ldg,
123: gl_ledger_set_assignments lsa
124: WHERE lsa.ledger_set_id = x_ledger_id
125: AND ldg.ledger_id = lsa.ledger_id
126: AND ldg.object_type_code = 'L'

Line 149: FROM gl_ledgers ldg, gl_ledger_set_assignments lsa

145: ELSE -- Ledger Set
146: IF (x_ledger_currency = 'STAT') THEN
147: SELECT count(DISTINCT ldg.currency_code)
148: INTO dummy_num
149: FROM gl_ledgers ldg, gl_ledger_set_assignments lsa
150: WHERE lsa.ledger_set_id = x_ledger_id
151: AND ldg.ledger_id = lsa.ledger_id
152: AND ldg.object_type_code = 'L';
153: