APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_LEVELS

Line 1064: from msd_st_level_values a, msd_levels b

1060:
1061: /* Cursor for staging table */
1062: CURSOR c_st_level is
1063: select distinct a.instance, a.level_id
1064: from msd_st_level_values a, msd_levels b
1065: where a.level_id = b.level_id and
1066: a.instance <> 0 and
1067: b.level_type_code = 3 and
1068: a.instance = p_instance;

Line 1075: from msd_level_values a, msd_levels b

1071: /* Cursor for fact table */
1072: /* Bug# 4919130 - Always delete childless parents from staging table.
1073: CURSOR c_level is
1074: select distinct a.instance, a.level_id
1075: from msd_level_values a, msd_levels b
1076: where a.level_id = b.level_id and
1077: a.instance <> 0 and
1078: b.level_type_code = 3 and
1079: a.instance = p_instance;