APPS.CE_CSH_FCST_POP dependencies on GL_PERIODS

Line 121: FROM gl_periods gps,

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

Line 122: gl_periods gp,

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

Line 1083: l_period_name GL_PERIODS.period_name%TYPE;

1079: --------------------------------------------------------------------- */
1080: FUNCTION Use_Avg_Bal_Pos(p_ccid NUMBER) RETURN NUMBER IS
1081: l_end_of_day NUMBER;
1082: l_ptd_range NUMBER;
1083: l_period_name GL_PERIODS.period_name%TYPE;
1084: BEGIN
1085: cep_standard.debug('>>CE_CSH_FCST_POP.Use_Avg_Bal_Pos');
1086: --
1087: -- Get number of days from start of the period

Line 1094: FROM gl_periods

1090: SELECT period_name,
1091: (CE_CASH_FCST.G_rp_forecast_start_date - start_date +1)
1092: INTO l_period_name,
1093: l_ptd_range
1094: FROM gl_periods
1095: WHERE CE_CASH_FCST.G_rp_forecast_start_date BETWEEN start_date and end_date
1096: AND period_set_name = CE_CASH_FCST.G_rp_calendar_name;
1097:
1098: EXCEPTION

Line 1223: gl_periods gp,

1219: INTO begin_period,
1220: begin_cash_bal
1221: FROM gl_balances src,
1222: gl_sets_of_books org,
1223: gl_periods gp,
1224: gl_code_combinations glcc,
1225: ce_currency_rates_temp curr
1226: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1227: AND curr.currency_code = src.currency_code

Line 1418: from gl_periods

1414: l_fc_start_date := trunc(CE_CASH_FCST.G_rp_forecast_start_date);
1415: ELSE
1416: select trunc(start_date)
1417: into l_fc_start_date
1418: from gl_periods
1419: where period_set_name = CE_CASH_FCST.G_rp_calendar_name
1420: and period_name = CE_CASH_FCST.G_rp_forecast_start_period;
1421: END IF;
1422:

Line 2656: gl_periods gp,

2652: END IF;
2653:
2654: main_query := main_query || '
2655: FROM gl_balances src,
2656: gl_periods gp,
2657: ce_forecast_ext_temp cab ';
2658:
2659: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2660: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN