APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 28: RETURN cn_acc_period_statuses_v.end_date%TYPE

24: FUNCTION cn_end_date_period
25: (
26: p_end_date DATE,
27: p_org_id NUMBER)
28: RETURN cn_acc_period_statuses_v.end_date%TYPE
29: IS
30: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
31: BEGIN
32: SELECT end_date

Line 30: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;

26: p_end_date DATE,
27: p_org_id NUMBER)
28: RETURN cn_acc_period_statuses_v.end_date%TYPE
29: IS
30: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
31: BEGIN
32: SELECT end_date
33: INTO l_next_end_date
34: FROM cn_acc_period_statuses_v

Line 34: FROM cn_acc_period_statuses_v

30: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
31: BEGIN
32: SELECT end_date
33: INTO l_next_end_date
34: FROM cn_acc_period_statuses_v
35: WHERE p_end_date BETWEEN start_date AND end_date
36: AND org_id = p_org_id;
37: RETURN l_next_end_date;
38: EXCEPTION

Line 731: cn_acc_period_statuses_v p

727: qa.org_id
728: FROM cn_srp_quota_assigns_all qa ,
729: cn_quotas_all q ,
730: cn_srp_plan_assigns_all pa ,
731: cn_acc_period_statuses_v p
732: -- bug fix 4042235
733: ,
734: cn_period_statuses p2 ,
735: cn_period_statuses p3