APPS.XLA_DRILLDOWN_PKG dependencies on XLA_SUBLEDGERS

Line 134: CURSOR c_xla_subledgers

130:
131: --
132: -- Cursor declaration
133: --
134: CURSOR c_xla_subledgers
135: IS
136: SELECT application_id, je_source_name
137: FROM xla_subledgers
138: WHERE je_source_name = p_je_source;

Line 137: FROM xla_subledgers

133: --
134: CURSOR c_xla_subledgers
135: IS
136: SELECT application_id, je_source_name
137: FROM xla_subledgers
138: WHERE je_source_name = p_je_source;
139:
140: CURSOR c_je_from_sla_flag
141: IS

Line 147: OPEN c_xla_subledgers;

143: FROM gl_je_headers
144: WHERE je_header_id = p_je_header_id;
145:
146: BEGIN
147: OPEN c_xla_subledgers;
148: FETCH c_xla_subledgers INTO l_appl_id, l_je_source_name;
149: CLOSE c_xla_subledgers;
150:
151: OPEN c_je_from_sla_flag;

Line 148: FETCH c_xla_subledgers INTO l_appl_id, l_je_source_name;

144: WHERE je_header_id = p_je_header_id;
145:
146: BEGIN
147: OPEN c_xla_subledgers;
148: FETCH c_xla_subledgers INTO l_appl_id, l_je_source_name;
149: CLOSE c_xla_subledgers;
150:
151: OPEN c_je_from_sla_flag;
152: FETCH c_je_from_sla_flag INTO l_je_from_sla_flag;

Line 149: CLOSE c_xla_subledgers;

145:
146: BEGIN
147: OPEN c_xla_subledgers;
148: FETCH c_xla_subledgers INTO l_appl_id, l_je_source_name;
149: CLOSE c_xla_subledgers;
150:
151: OPEN c_je_from_sla_flag;
152: FETCH c_je_from_sla_flag INTO l_je_from_sla_flag;
153: CLOSE c_je_from_sla_flag;

Line 302: FROM xla_subledgers

298: l_je_line_num NUMBER(15);
299:
300: CURSOR c_xla IS
301: SELECT application_id
302: FROM xla_subledgers
303: WHERE je_source_name = p_je_source;
304:
305:
306: