DBA Data[Home] [Help]

APPS.GCS_ENTRY_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 129: FROM fem_cal_periods_attr fcpa_start_year,

125: THEN NULL
126: ELSE fcpa_start_year.number_assign_value + 1
127: END
128: INTO l_year_to_apply_re
129: FROM fem_cal_periods_attr fcpa_start_year,
130: fem_cal_periods_attr fcpa_end_year
131: WHERE fcpa_start_year.cal_period_id = ' ||
132: l_start_cal_period_id || '
133: AND fcpa_start_year.attribute_id = ' ||

Line 130: fem_cal_periods_attr fcpa_end_year

126: ELSE fcpa_start_year.number_assign_value + 1
127: END
128: INTO l_year_to_apply_re
129: FROM fem_cal_periods_attr fcpa_start_year,
130: fem_cal_periods_attr fcpa_end_year
131: WHERE fcpa_start_year.cal_period_id = ' ||
132: l_start_cal_period_id || '
133: AND fcpa_start_year.attribute_id = ' ||
134: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 157: FROM fem_cal_periods_attr fcpa_start_year,

153: ELSE
154: fcpa_start_year.number_assign_value + 1
155: END
156: INTO l_year_to_apply_re
157: FROM fem_cal_periods_attr fcpa_start_year,
158: fem_cal_periods_attr fcpa_end_year
159: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
160: AND fcpa_start_year.attribute_id =
161: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 158: fem_cal_periods_attr fcpa_end_year

154: fcpa_start_year.number_assign_value + 1
155: END
156: INTO l_year_to_apply_re
157: FROM fem_cal_periods_attr fcpa_start_year,
158: fem_cal_periods_attr fcpa_end_year
159: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
160: AND fcpa_start_year.attribute_id =
161: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
162: .attribute_id

Line 526: FROM fem_cal_periods_attr fcpa_start_year,

522: THEN NULL
523: ELSE fcpa_start_year.number_assign_value + 1
524: END
525: INTO l_year_to_apply_re
526: FROM fem_cal_periods_attr fcpa_start_year,
527: fem_cal_periods_attr fcpa_end_year
528: WHERE fcpa_start_year.cal_period_id = ' ||
529: l_start_cal_period_id || '
530: AND fcpa_start_year.attribute_id = ' ||

Line 527: fem_cal_periods_attr fcpa_end_year

523: ELSE fcpa_start_year.number_assign_value + 1
524: END
525: INTO l_year_to_apply_re
526: FROM fem_cal_periods_attr fcpa_start_year,
527: fem_cal_periods_attr fcpa_end_year
528: WHERE fcpa_start_year.cal_period_id = ' ||
529: l_start_cal_period_id || '
530: AND fcpa_start_year.attribute_id = ' ||
531: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 583: FROM fem_cal_periods_attr fcpa_start_year,

579: ELSE
580: fcpa_start_year.number_assign_value + 1
581: END
582: INTO l_year_to_apply_re
583: FROM fem_cal_periods_attr fcpa_start_year,
584: fem_cal_periods_attr fcpa_end_year
585: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
586: AND fcpa_start_year.attribute_id =
587: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 584: fem_cal_periods_attr fcpa_end_year

580: fcpa_start_year.number_assign_value + 1
581: END
582: INTO l_year_to_apply_re
583: FROM fem_cal_periods_attr fcpa_start_year,
584: fem_cal_periods_attr fcpa_end_year
585: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
586: AND fcpa_start_year.attribute_id =
587: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
588: .attribute_id