APPS.MSD_CS_CLMN_DIM_LOAD_DATA dependencies on MSD_CS_DEFINITIONS

Line 59: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and

55: last_updated_by,
56: last_update_date
57: from MSD_CS_CLMN_DIM_DTLS_V
58: where
59: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and
60: table_column = p_table_column and
61: dimension_code = p_dimension_code;
62:
63: f_ludate date; -- entity update date in file

Line 134: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and

130: cursor c1 is
131: select cs_defn_dim_dtls_id
132: from msd_cs_defn_dim_dtls
133: where
134: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and
135: dimension_code = p_dimension_code;
136: --
137: cursor c2 is
138: select cs_column_dtls_id

Line 140: where cs_definition_id = (select cs_definition_id from msd_cs_definitions where name =p_definition_name)

136: --
137: cursor c2 is
138: select cs_column_dtls_id
139: from msd_cs_defn_column_dtls
140: where cs_definition_id = (select cs_definition_id from msd_cs_definitions where name =p_definition_name)
141: and table_column = p_table_column;
142:
143: Begin
144: --