DBA Data[Home] [Help]

APPS.GCS_INTERCO_PROCESSING_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 189: FROM fem_cal_periods_attr fcpa

185:
186:
187: SELECT DATE_ASSIGN_VALUE
188: INTO g_period_start_date
189: FROM fem_cal_periods_attr fcpa
190: WHERE fcpa.cal_period_id = p_cal_period_id
191: AND fcpa.attribute_id =
192: g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').attribute_id
193: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').version_id;

Line 197: FROM fem_cal_periods_attr fcpa

193: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').version_id;
194:
195: SELECT DATE_ASSIGN_VALUE
196: INTO g_period_end_date
197: FROM fem_cal_periods_attr fcpa
198: WHERE fcpa.cal_period_id = p_cal_period_id
199: AND fcpa.attribute_id =
200: g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
201: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;