APPS.MSD_PURGE dependencies on MSD_CS_DEFINITIONS

Line 25: FROM msd_cs_definitions

21: */
22:
23: CURSOR get_cs_definition_id(p_cs_name in VARCHAR2) IS
24: SELECT cs_definition_id
25: FROM msd_cs_definitions
26: WHERE name = p_cs_name;
27:
28: CURSOR get_cs_system_flag(p_cs_iden in VARCHAR2) IS
29: SELECT system_flag

Line 30: FROM msd_cs_definitions

26: WHERE name = p_cs_name;
27:
28: CURSOR get_cs_system_flag(p_cs_iden in VARCHAR2) IS
29: SELECT system_flag
30: FROM msd_cs_definitions
31: WHERE cs_definition_id = p_cs_iden;
32:
33:
34: /* Helper Functions */

Line 55: from msd_cs_definitions

51: cursor get_cs_data is
52: select cs_data_id
53: from msd_cs_data
54: where cs_definition_id in (select cs_definition_id
55: from msd_cs_definitions
56: where cs_definition_id = nvl(p_cs_definition_id , cs_definition_id)
57: and ((p_cs_definition_id is not null) or
58: (system_flag = 'C')))
59: and nvl(cs_name, '#$#$^&&&!!!!!!$%$%$%$%090@@') = nvl(p_cs_designator, nvl(cs_name, '#$#$^&&&!!!!!!$%$%$%$%090@@'))

Line 138: from msd_cs_definitions csd

134: where instance = nvl(p_instance_id, instance)
135: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
136: and cs_name = nvl(p_cs_name, cs_name)
137: and exists ( select 1
138: from msd_cs_definitions csd
139: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id
140: and csd.system_flag = 'C' );
141:
142: x_count number := 0;

Line 195: from msd_cs_definitions csd

191: where instance = nvl(p_instance_id, instance)
192: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
193: and cs_name = nvl(p_cs_name, cs_name)
194: and exists ( select 1
195: from msd_cs_definitions csd
196: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id
197: and csd.system_flag = 'C' );
198:
199: end if;