APPS.PJI_RM_SUM_AVL dependencies on FII_TIME_CAL_PERIOD

Line 1769: FII_TIME_CAL_PERIOD per,

1765: 0 as ROLL_X_WEEK_12,
1766: 0 as ROLL_X_WEEK_13
1767: FROM
1768: PJI_RM_AGGR_AVL1 avl_tmp1,
1769: FII_TIME_CAL_PERIOD per,
1770: FII_TIME_CAL_DAY_MV fiit
1771: WHERE
1772: avl_tmp1.PERIOD_ID = per.CAL_QTR_ID
1773: and avl_tmp1.gl_calendar_id = per.calendar_id

Line 2358: FROM fii_time_cal_period fiit

2354: ELSIF (l_gl_pd_count = 0) THEN
2355: BEGIN
2356: SELECT to_char(fiit.start_date,'j')
2357: INTO l_start_date_org_gl_pd
2358: FROM fii_time_cal_period fiit
2359: WHERE cal_period_id = l_gl_period_id;
2360: EXCEPTION
2361: WHEN NO_DATA_FOUND THEN
2362: NULL;