DBA Data[Home] [Help]

APPS.GMF_COPY_PERCENTAGE_BURDEN dependencies on CM_CLDR_MST_V

Line 195: FROM cm_cldr_mst_v a

191:
192: BEGIN
193: SELECT a.period_id
194: INTO l_period_id_from
195: FROM cm_cldr_mst_v a
196: WHERE a.legal_entity_id = pi_legal_entity_id_from
197: AND a.calendar_code = pi_calendar_code_from
198: AND a.period_code = pi_period_code_from
199: AND a.cost_type_id = pi_cost_type_id_from;

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

444: l_sql_periods := '' ;
445: l_sql_periods := 'SELECT DISTINCT ' ||
446: ' c3.period_id ' ||
447: 'FROM ' ||
448: 'cm_cldr_mst_v c3, cm_cldr_mst_v c2, cm_cldr_mst_v c1 ' ||
449: 'WHERE ' ||
450: 'c3.legal_entity_id = :pi_legal_entity_id AND ' ||
451: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
452: 'c1.period_code = :pi_all_periods_from AND ' ||

Line 474: FROM cm_cldr_mst_v a

470:
471: BEGIN
472: SELECT a.period_id
473: INTO pi_period_id_from
474: FROM cm_cldr_mst_v a
475: WHERE a.legal_entity_id = pi_legal_entity_id_from
476: AND a.calendar_code = pi_calendar_code_from
477: AND a.period_code = pi_period_code_from
478: AND a.cost_type_id = pi_cost_type_id_from;

Line 491: FROM cm_cldr_mst_v a

487:
488: BEGIN
489: SELECT a.period_id
490: INTO pi_period_id_to
491: FROM cm_cldr_mst_v a
492: WHERE a.legal_entity_id = pi_legal_entity_id_to
493: AND a.calendar_code = pi_calendar_code_to
494: AND a.period_code = pi_period_code_to
495: AND a.cost_type_id = pi_cost_type_id_to;