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;

Line 822: msd_cs_definitions mcd

818: SELECT MIN(mdp.scn_build_refresh_num) ref_num,
819: mcd.cs_definition_id csid,
820: mcd.name csname
821: FROM msd_dp_parameters mdp,
822: msd_cs_definitions mcd
823: WHERE mcd.name = mdp.parameter_type
824: GROUP BY mcd.cs_definition_id,
825: mcd.name
826: ORDER BY mcd.cs_definition_id;