DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_REPOSITORIES_ALL

Line 1157: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

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

Line 1168: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

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;