APPS.MSD_TRANSLATE_FACT_DATA dependencies on DUAL

Line 1327: forecast_date and rate_end_date of individual raw entity. This INSERT

1323: dates according to the calendar. We split raw entity by inserting all the sub
1324: entities into msd_mfg_forecast talbe and delete the original raw entity from
1325: that table. When we insert sub entities into msd_mfg_forecast table, we join
1326: this table with msd_st_time table and only select days which is in between
1327: forecast_date and rate_end_date of individual raw entity. This INSERT
1328: statement contains 3 SELECT statement according to raw entities bucket_type.
1329: We connect the results with UNION. Only one SELECT statement will be
1330: executed due to different bucket_type condition.
1331: Once we insert all sub entity, we delte all raw entities, and delete

Line 1926: p_ref_num from dual;

1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id,
1926: p_ref_num from dual;
1927:
1928: end if;
1929:
1930: end populate_cs_data_header;