APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_PERIOD_STATUSES

Line 39: RETURN cn_period_statuses.end_date%TYPE IS

35: -- Purpose
36: -- Get the Next period
37: -- -------------------------------------------------------------------------+
38: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
39: RETURN cn_period_statuses.end_date%TYPE IS
40:
41: l_next_end_date cn_period_statuses.end_date%TYPE;
42:
43: BEGIN

Line 41: l_next_end_date cn_period_statuses.end_date%TYPE;

37: -- -------------------------------------------------------------------------+
38: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
39: RETURN cn_period_statuses.end_date%TYPE IS
40:
41: l_next_end_date cn_period_statuses.end_date%TYPE;
42:
43: BEGIN
44:
45: SELECT MAX(end_date)

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