APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_REPOSITORIES_ALL

Line 47: FROM cn_period_statuses_all s, cn_repositories_all r

43: BEGIN
44:
45: SELECT MAX(end_date)
46: INTO l_next_end_date
47: FROM cn_period_statuses_all s, cn_repositories_all r
48: WHERE s.period_type_id = r.period_type_id
49: AND s.period_set_id = r.period_set_id
50: AND s.org_id = p_org_id
51: AND r.org_id = p_org_id;

Line 57: FROM cn_period_statuses_all s, cn_repositories_all r

53: IF trunc(l_next_end_date) > trunc(p_end_date) THEN
54:
55: SELECT MIN(end_date)
56: INTO l_next_end_date
57: FROM cn_period_statuses_all s, cn_repositories_all r
58: WHERE trunc(end_date) >= trunc(p_end_date)
59: AND s.period_type_id = r.period_type_id
60: AND s.period_set_id = r.period_set_id
61: AND s.org_id = p_org_id