APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;

355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;
358:
359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;
360:
361: CURSOR c IS
362: SELECT * FROM CN_SRP_PLAN_ASSIGNS_ALL
363: WHERE SRP_PLAN_ASSIGN_ID = X_SRP_PLAN_ASSIGN_ID

Line 555: FROM cn_acc_period_statuses_v

551: ELSIF x_end_date > oldrow.end_date THEN
552: -- extend end_date
553: SELECT MIN(start_date)
554: INTO l_next_start_date
555: FROM cn_acc_period_statuses_v
556: WHERE period_status IN ('F', 'O')
557: AND org_id = oldrow.org_id;
558:
559: IF x_end_date > l_next_start_date THEN