APPS.CN_PERIODS_API dependencies on CN_REPOSITORIES

Line 979: FROM cn_repositories

975: l_period_quota_id number(15);
976:
977: CURSOR repository IS
978: SELECT period_set_id, period_type_id
979: FROM cn_repositories
980: WHERE org_id = x_org_id;
981: CURSOR interval_types IS
982: SELECT interval_type_id
983: FROM cn_interval_types

Line 1129: -- UPDATE cn_repositories

1125: END IF;
1126:
1127: -- Set repository status to F = Frozen. Per WFRIEND. 07-21-95.
1128: -- Removed. Per WFRIEND. 08-03-95.
1129: -- UPDATE cn_repositories
1130: -- SET status = 'F'
1131: -- WHERE repository_id = x_repository_id ;
1132:
1133: END Check_CN_Period_Record;

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;