APPS.MSD_TRANSLATE_FACT_DATA dependencies on DUAL

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

1397: dates according to the calendar. We split raw entity by inserting all the sub
1398: entities into msd_mfg_forecast talbe and delete the original raw entity from
1399: that table. When we insert sub entities into msd_mfg_forecast table, we join
1400: this table with msd_st_time table and only select days which is in between
1401: forecast_date and rate_end_date of individual raw entity. This INSERT
1402: statement contains 3 SELECT statement according to raw entities bucket_type.
1403: We connect the results with UNION. Only one SELECT statement will be
1404: executed due to different bucket_type condition.
1405: Once we insert all sub entity, we delte all raw entities, and delete

Line 2036: p_ref_num from dual;

2032: fnd_global.user_id,
2033: sysdate,
2034: fnd_global.user_id,
2035: fnd_global.login_id,
2036: p_ref_num from dual;
2037:
2038: end if;
2039:
2040: end populate_cs_data_header;