APPS.BIM_PROGRAMS_DENORM_PKG dependencies on BIM_I_SOURCE_CODES

Line 223: FROM bim_i_source_codes a

219:
220: DELETE bim_i_source_denorm
221: WHERE source_code_id IN
222: (SELECT source_code_id
223: FROM bim_i_source_codes a
224: WHERE obj_last_update_date > l_temp_start_date
225: );
226:
227: /* This piece of code is for the campaigns that have changed from one program to another. */

Line 237: bim_i_source_codes b

233: WHERE parent_source_code_id IN
234: (
235: SELECT b.source_code_id
236: FROM ams_campaigns_all_b a,
237: bim_i_source_codes b
238: WHERE a.rollup_type in ('RCAM')
239: and b.source_code_id = (-1)*b.object_id
240: AND obj_last_update_date > l_temp_start_date
241: )

Line 253: FROM bim_i_source_codes b

249: FROM bim_i_source_denorm
250: WHERE parent_source_code_id IN
251: (
252: SELECT b.source_code_id
253: FROM bim_i_source_codes b
254: WHERE b.source_code_id = (-1)*b.object_id
255: AND obj_last_update_date > l_temp_start_date
256: )
257:

Line 280: FROM bim_i_source_codes a

276: WHERE source_code_id
277: IN
278: (
279: SELECT parent_source_code_id
280: FROM bim_i_source_codes a
281: WHERE rollup_type in ('CSCH', 'EVE0')
282: AND NOT EXISTS (
283: SELECT 1
284: FROM bim_i_source_denorm b

Line 347: WHEN (select 'Y' from bim_i_source_codes b

343: ,decode(parent_source_code_id, NULL, 'Y', 'N') top_node_flag
344: ,(CASE
345: WHEN rollup_type in ('CSCH','EVEO','EONE') THEN 'Y'
346: WHEN source_code_id < 0 THEN 'N'
347: WHEN (select 'Y' from bim_i_source_codes b
348: where a.object_id = b.object_id
349: and a.object_type = b.object_type
350: and b.object_type in ('CAMP','EVEH')
351: and b.child_object_id > 0

Line 357: FROM bim_i_source_codes a

353: ELSE 'N'
354: END
355: ) leaf_node_flag
356:
357: FROM bim_i_source_codes a
358: WHERE
359: NOT EXISTS
360: (SELECT 1
361: FROM BIM_I_SOURCE_DENORM b

Line 366: BIM_I_SOURCE_CODES s

362: WHERE b.source_code_id = a.source_code_id
363: -- AND nvl(b.parent_object_id,1) = nvl(a.parent_campaign_id,1)
364: )
365: CONNECT BY PRIOR source_code_id = parent_source_code_id ) x,
366: BIM_I_SOURCE_CODES s
367: WHERE s.source_code_id = x.parent_source_code_id;
368:
369: null;
370:

Line 433: WHEN (select 'Y' from bim_i_source_codes b

429: ,decode(parent_source_code_id, NULL, 'Y', 'N') top_node_flag
430: ,(CASE
431: WHEN rollup_type in ('CSCH','EVEO','EONE') THEN 'Y'
432: WHEN source_code_id < 0 THEN 'N'
433: WHEN (select 'Y' from bim_i_source_codes b
434: where a.object_id = b.object_id
435: and a.object_type = b.object_type
436: and b.object_type in ('CAMP','EVEH')
437: and b.child_object_id > 0

Line 443: FROM bim_i_source_codes a

439: ELSE 'N'
440: END
441: ) leaf_node_flag
442:
443: FROM bim_i_source_codes a
444: CONNECT BY PRIOR source_code_id = parent_source_code_id ) x,
445: BIM_I_SOURCE_CODES s
446: WHERE s.source_code_id = x.parent_source_code_id
447: UNION ALL

Line 445: BIM_I_SOURCE_CODES s

441: ) leaf_node_flag
442:
443: FROM bim_i_source_codes a
444: CONNECT BY PRIOR source_code_id = parent_source_code_id ) x,
445: BIM_I_SOURCE_CODES s
446: WHERE s.source_code_id = x.parent_source_code_id
447: UNION ALL
448: SELECT
449: -1 source_code_id

Line 640: bim_i_source_codes code1,

636: max(b.object_level) object_level ,
637: a.object_type object_type
638: FROM ams_act_access_denorm a,
639: bim_i_source_denorm b,
640: bim_i_source_codes code1,
641: ams_act_access_denorm c,
642: bim_i_source_codes code2
643: WHERE a.object_id = code1.object_id
644: AND a.object_type = code1.object_type

Line 642: bim_i_source_codes code2

638: FROM ams_act_access_denorm a,
639: bim_i_source_denorm b,
640: bim_i_source_codes code1,
641: ams_act_access_denorm c,
642: bim_i_source_codes code2
643: WHERE a.object_id = code1.object_id
644: AND a.object_type = code1.object_type
645: AND b.source_code_id=code1.source_code_id
646: AND code1.object_type in ('RCAM', 'CAMP', 'EVEH', 'EONE')