1153: x_end_date OUT nocopy DATE) IS
1154:
1155: CURSOR get_dates (p_period_id NUMBER) is
1156: SELECT cn.start_date, cn.end_date
1157: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1158: WHERE rp.period_set_id = cn.period_set_id
1159: AND rp.period_type_id = cn.period_type_id
1160: AND cn.org_id = rp.org_id
1161: AND cn.org_id = x_org_id
1164: date_rec get_dates%ROWTYPE;
1165:
1166: CURSOR get_min_date IS
1167: SELECT MIN(cn.start_date)
1168: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1169: WHERE rp.period_set_id = cn.period_set_id
1170: AND rp.period_type_id = cn.period_type_id
1171: AND cn.org_id = rp.org_id
1172: AND cn.org_id = x_org_id;