APPS.CN_SEAS_SCHEDULES_PVT dependencies on CN_CAL_PER_INT_TYPES

Line 59: FROM cn_period_statuses cp,cn_cal_per_int_types ccpit

55: l_cal_int_types NUMBER;
56:
57: CURSOR cn_seasonalities_cur(p_period_year NUMBER) IS
58: SELECT cp.period_id,cp.period_name,ccpit.interval_number,ccpit.cal_per_int_type_id
59: FROM cn_period_statuses cp,cn_cal_per_int_types ccpit
60: WHERE period_year = p_period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;
61:
62:
63: BEGIN

Line 152: FROM cn_period_statuses cp,cn_cal_per_int_types ccpit

148: --DBMS_OUTPUT.PUT_LINE('Inserted Row and SEAS SCHEDULE ID is : ' || l_seas_schedule_id || 'About to get rows for ' || p_seas_schedules_rec_type.period_year);
149:
150:
151: SELECT COUNT(*) INTO l_cal_int_types
152: FROM cn_period_statuses cp,cn_cal_per_int_types ccpit
153: WHERE period_year = p_seas_schedules_rec_type.period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;
154:
155: IF (l_cal_int_types = 0) THEN
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN