APPS.BIM_PROGRAMS_DENORM_PKG dependencies on BIM_I_ADMIN_GROUP

Line 536: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_admin_group';

532:
533: BEGIN
534:
535: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
536: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_admin_group';
537:
538:
539: INSERT INTO bim_i_admin_group
540: (

Line 539: INSERT INTO bim_i_admin_group

535: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
536: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_admin_group';
537:
538:
539: INSERT INTO bim_i_admin_group
540: (
541: Resource_Id
542: )
543: SELECT resource_id

Line 650: (SELECT resource_id FROM bim_i_admin_group WHERE resource_id = a.resource_id)

646: AND code1.object_type in ('RCAM', 'CAMP', 'EVEH', 'EONE')
647: AND code1.child_object_id=0
648: AND a.edit_metrics_yn = 'Y'
649: AND NOT EXISTS
650: (SELECT resource_id FROM bim_i_admin_group WHERE resource_id = a.resource_id)
651: AND c.resource_id = a.resource_id
652: AND c.object_id = code2.object_id
653: AND c.object_type = code2.object_type
654: AND code2.source_code_id=b.parent_source_code_id