APPS.GMF_COPY_RSRC_COST dependencies on CM_CLDR_MST_V

Line 129: FROM cm_cldr_mst_v

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

Line 147: FROM cm_cldr_mst_v

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

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

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