669: cursor l_pago_cal_periods_csr (
670: p_cal_period_id in number
671: ) is
672: select cp2.cal_period_id
673: from fem_cal_periods_b cp
674: ,fem_cal_periods_attr cpa_adj
675: ,fem_cal_periods_b cp2
676: ,fem_cal_periods_attr cpa2_adj
677: ,fem_dimensions_b dim
671: ) is
672: select cp2.cal_period_id
673: from fem_cal_periods_b cp
674: ,fem_cal_periods_attr cpa_adj
675: ,fem_cal_periods_b cp2
676: ,fem_cal_periods_attr cpa2_adj
677: ,fem_dimensions_b dim
678: ,fem_dim_attributes_b a
679: ,fem_dim_attr_versions_b v
744: cursor l_yago_cal_periods_csr (
745: p_cal_period_id in number
746: ) is
747: select cp2.cal_period_id
748: from fem_cal_periods_b cp
749: ,fem_cal_periods_attr cpa_adj
750: ,fem_cal_periods_attr cpa_start
751: ,fem_cal_periods_attr cpa_end
752: ,fem_cal_periods_b cp2
748: from fem_cal_periods_b cp
749: ,fem_cal_periods_attr cpa_adj
750: ,fem_cal_periods_attr cpa_start
751: ,fem_cal_periods_attr cpa_end
752: ,fem_cal_periods_b cp2
753: ,fem_cal_periods_attr cpa2_adj
754: ,fem_cal_periods_attr cpa2_start
755: ,fem_cal_periods_attr cpa2_end
756: ,fem_dimensions_b dim