APPS.GMF_COPY_RSRC_COST dependencies on CM_CLDR_MST_V

Line 128: FROM cm_cldr_mst_v

124:
125: BEGIN
126: SELECT period_id
127: INTO l_period_id_from
128: FROM cm_cldr_mst_v
129: WHERE legal_entity_id = pi_legal_entity_id_from
130: AND calendar_code = pi_calendar_code_from
131: AND period_code = pi_period_code_from
132: AND cost_type_id = pi_cost_type_id_from;

Line 146: FROM cm_cldr_mst_v

142: IF (pi_period_code_to IS NOT NULL) THEN
143: BEGIN
144: SELECT period_id
145: INTO pi_period_id_to
146: FROM cm_cldr_mst_v
147: WHERE legal_entity_id = pi_legal_entity_id_to
148: AND calendar_code = pi_calendar_code_to
149: AND period_code = pi_period_code_to
150: AND cost_type_id = pi_cost_type_id_to;

Line 237: 'cm_cldr_mst_v c3, cm_cldr_mst_v c2, cm_cldr_mst_v c1 ' ||

233: l_sql_periods := '' ;
234: l_sql_periods := 'SELECT DISTINCT ' ||
235: 'c3.legal_entity_id, c3.period_id ' ||
236: 'FROM ' ||
237: 'cm_cldr_mst_v c3, cm_cldr_mst_v c2, cm_cldr_mst_v c1 ' ||
238: 'WHERE ' ||
239: 'c3.legal_entity_id = :pi_legal_entity_id_to AND '||
240: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
241: 'c1.period_code = :pi_all_periods_from AND ' ||