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 1014: FROM msd_cs_definitions

1010: x_cs_id number;
1011:
1012: CURSOR get_cs_id(p_cs_name in VARCHAR2) IS
1013: SELECT cs_definition_id
1014: FROM msd_cs_definitions
1015: WHERE name = p_cs_name;
1016:
1017:
1018: Begin

Line 1892: from msd_cs_definitions

1888: p_ref_num in number) is
1889:
1890: cursor get_cs_id is
1891: select cs_definition_id
1892: from msd_cs_definitions
1893: where name = p_name;
1894:
1895: x_cs_id number;
1896: