APPS.CN_SEAS_SCHEDULES_PVT dependencies on CN_PERIOD_STATUSES

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 125: from cn_period_statuses

121:
122: -- INSERT TO BEGIN TO CN_SEAS_SCHEDULES
123: -- Get the Max Date of End Date and Min of Start Date for this period Year.
124: select min(start_date),max(end_date) into l_start_date,l_end_date
125: from cn_period_statuses
126: where period_year = p_seas_schedules_rec_type.period_year
127: group by period_year;
128:
129: -- We can put some more error conditon checks for Start Date and End Date.

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