APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_CS_DEFINITIONS

Line 223: from msd_cs_definitions

219:
220: select 1 into v_ref_num
221: from msd_cs_data_headers
222: where cs_definition_id in (select cs_definition_id
223: from msd_cs_definitions
224: where name = 'MSD_SHIPMENT_HISTORY');
225:
226: update msd_cs_data_headers
227: set last_refresh_num = p_new_refresh_num

Line 229: from msd_cs_definitions

225:
226: update msd_cs_data_headers
227: set last_refresh_num = p_new_refresh_num
228: where cs_definition_id in (select cs_definition_id
229: from msd_cs_definitions
230: where name in ('MSD_SHIPMENT_HISTORY','MSD_SHIPMENT_ORIG_HISTORY'));
231:
232: Exception When No_Data_Found Then
233: populate_cs_data_header(p_instance_id,

Line 451: from msd_cs_definitions

447:
448: select 1 into v_ref_num
449: from msd_cs_data_headers
450: where cs_definition_id in (select cs_definition_id
451: from msd_cs_definitions
452: where name = 'MSD_BOOKING_HISTORY');
453:
454: update msd_cs_data_headers
455: set last_refresh_num = p_new_refresh_num

Line 457: from msd_cs_definitions

453:
454: update msd_cs_data_headers
455: set last_refresh_num = p_new_refresh_num
456: where cs_definition_id in (select cs_definition_id
457: from msd_cs_definitions
458: where name in ('MSD_BOOKING_HISTORY','MSD_BOOKING_ORIG_HISTORY'));
459:
460: Exception When No_Data_Found Then
461: populate_cs_data_header(p_instance_id,

Line 1088: FROM msd_cs_definitions

1084: x_cs_id number;
1085:
1086: CURSOR get_cs_id(p_cs_name in VARCHAR2) IS
1087: SELECT cs_definition_id
1088: FROM msd_cs_definitions
1089: WHERE name = p_cs_name;
1090:
1091:
1092: Begin

Line 1947: msd_cs_definitions mcd

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;
1951:

Line 2002: from msd_cs_definitions

1998: p_ref_num in number) is
1999:
2000: cursor get_cs_id is
2001: select cs_definition_id
2002: from msd_cs_definitions
2003: where name = p_name;
2004:
2005: x_cs_id number;
2006: