APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_DP_PARAMETERS

Line 1946: FROM msd_dp_parameters dp,

1942: last_refresh_num;
1943:
1944: CURSOR scn_build_ref_num IS
1945: SELECT dp.scn_build_refresh_num bldn
1946: FROM msd_dp_parameters dp,
1947: msd_cs_definitions mcd
1948: WHERE mcd.cs_definition_id = p_cs_definition_id
1949: AND mcd.name = dp.parameter_type
1950: AND dp.scn_build_refresh_num IS NOT NULL;

Line 1979: FROM msd_dp_parameters;

1975: END LOOP;
1976:
1977: ELSE
1978: SELECT nvl(min(scn_build_refresh_num), 0) INTO l_least_refresh_num
1979: FROM msd_dp_parameters;
1980: l_sql_stmt := ' DELETE FROM ' || p_table_name ||
1981: ' WHERE ACTION_CODE = ' || '''D''' ||
1982: ' and LAST_REFRESH_NUM <= ' || l_least_refresh_num;
1983: EXECUTE IMMEDIATE l_sql_stmt;