DBA Data[Home] [Help]

APPS.PA_PERIODS_PKG dependencies on PJI_TIME_CAL_PERIOD

Line 225: l_pji_name pji_time_cal_period.NAME%TYPE;

221:
222: l_temp varchar2(1);
223: l_period_name pa_periods_all.period_name%TYPE;
224:
225: l_pji_name pji_time_cal_period.NAME%TYPE;
226:
227: l_rec_count NUMBER;
228:
229:

Line 274: pji_time_cal_period prd

270:
271: SELECT COUNT(*)
272: INTO l_rec_count
273: FROM pa_time_cal_name cal, /* Modified for bug 12979524 */
274: pji_time_cal_period prd
275: WHERE cal.period_set_name = p_period_set_name
276: AND prd.name = p_period_name
277: AND prd.calendar_id = cal.calendar_id
278: AND ROWNUM =1;