APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_LEVELS

Line 1147: from msd_st_level_values a, msd_levels b

1143:
1144: /* Cursor for staging table */
1145: CURSOR c_st_level is
1146: select distinct a.instance, a.level_id
1147: from msd_st_level_values a, msd_levels b
1148: where a.level_id = b.level_id and
1149: a.instance <> 0 and
1150: b.level_type_code = 3 and
1151: a.instance = p_instance;

Line 1158: from msd_level_values a, msd_levels b

1154: /* Cursor for fact table */
1155: /* Bug# 4919130 - Always delete childless parents from staging table.
1156: CURSOR c_level is
1157: select distinct a.instance, a.level_id
1158: from msd_level_values a, msd_levels b
1159: where a.level_id = b.level_id and
1160: a.instance <> 0 and
1161: b.level_type_code = 3 and
1162: a.instance = p_instance;