APPS.CN_PERIODS_API dependencies on CN_REPOSITORIES_ALL

Line 1153: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

1149: x_end_date OUT nocopy DATE) IS
1150:
1151: CURSOR get_dates (p_period_id NUMBER) is
1152: SELECT cn.start_date, cn.end_date
1153: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1154: WHERE rp.period_set_id = cn.period_set_id
1155: AND rp.period_type_id = cn.period_type_id
1156: AND cn.org_id = rp.org_id
1157: AND cn.org_id = x_org_id

Line 1164: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

1160: date_rec get_dates%ROWTYPE;
1161:
1162: CURSOR get_min_date IS
1163: SELECT MIN(cn.start_date)
1164: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1165: WHERE rp.period_set_id = cn.period_set_id
1166: AND rp.period_type_id = cn.period_type_id
1167: AND cn.org_id = rp.org_id
1168: AND cn.org_id = x_org_id;