APPS.CE_CSH_FCST_POP dependencies on GL_PERIODS

Line 118: FROM gl_periods gps,

114: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'A') THEN
115: BEGIN
116: SELECT gps.period_name
117: INTO history_period
118: FROM gl_periods gps,
119: gl_periods gp,
120: gl_period_types gpt
121: WHERE gps.period_num =DECODE(LEAST(gp.period_num-CE_CASH_FCST.G_roll_forward_period,1),
122: 1,gp.period_num - CE_CASH_FCST.G_roll_forward_period,

Line 119: gl_periods gp,

115: BEGIN
116: SELECT gps.period_name
117: INTO history_period
118: FROM gl_periods gps,
119: gl_periods gp,
120: gl_period_types gpt
121: WHERE gps.period_num =DECODE(LEAST(gp.period_num-CE_CASH_FCST.G_roll_forward_period,1),
122: 1,gp.period_num - CE_CASH_FCST.G_roll_forward_period,
123: gpt.number_per_fiscal_year +

Line 1015: l_period_name GL_PERIODS.period_name%TYPE;

1011: --------------------------------------------------------------------- */
1012: FUNCTION Use_Avg_Bal_Pos(p_ccid NUMBER) RETURN NUMBER IS
1013: l_end_of_day NUMBER;
1014: l_ptd_range NUMBER;
1015: l_period_name GL_PERIODS.period_name%TYPE;
1016: BEGIN
1017: cep_standard.debug('>>CE_CSH_FCST_POP.Use_Avg_Bal_Pos');
1018: --
1019: -- Get number of days from start of the period

Line 1026: FROM gl_periods

1022: SELECT period_name,
1023: (CE_CASH_FCST.G_rp_forecast_start_date - start_date +1)
1024: INTO l_period_name,
1025: l_ptd_range
1026: FROM gl_periods
1027: WHERE CE_CASH_FCST.G_rp_forecast_start_date BETWEEN start_date and end_date
1028: AND period_set_name = CE_CASH_FCST.G_rp_calendar_name;
1029:
1030: EXCEPTION

Line 1155: gl_periods gp,

1151: INTO begin_period,
1152: begin_cash_bal
1153: FROM gl_balances src,
1154: gl_sets_of_books org,
1155: gl_periods gp,
1156: gl_code_combinations glcc,
1157: ce_currency_rates_temp curr
1158: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1159: AND curr.currency_code = src.currency_code

Line 1349: from gl_periods

1345: l_fc_start_date := trunc(CE_CASH_FCST.G_rp_forecast_start_date);
1346: ELSE
1347: select trunc(start_date)
1348: into l_fc_start_date
1349: from gl_periods
1350: where period_set_name = CE_CASH_FCST.G_rp_calendar_name
1351: and period_name = CE_CASH_FCST.G_rp_forecast_start_period;
1352: END IF;
1353:

Line 2580: gl_periods gp,

2576: END IF;
2577:
2578: main_query := main_query || '
2579: FROM gl_balances src,
2580: gl_periods gp,
2581: ce_forecast_ext_temp cab ';
2582:
2583: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2584: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN