APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 33: RETURN cn_acc_period_statuses_v.end_date%TYPE IS

29: -- 14-Sep-04 jasingh Fixed the Bug# 3848446
30:
31: FUNCTION cn_end_date_period(p_end_date DATE, p_org_id NUMBER)
32:
33: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
34:
35: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
36:
37: BEGIN

Line 35: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;

31: FUNCTION cn_end_date_period(p_end_date DATE, p_org_id NUMBER)
32:
33: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
34:
35: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
36:
37: BEGIN
38:
39: SELECT end_date

Line 41: FROM cn_acc_period_statuses_v

37: BEGIN
38:
39: SELECT end_date
40: INTO l_next_end_date
41: FROM cn_acc_period_statuses_v
42: WHERE p_end_date between start_date and end_date
43: AND org_id = p_org_id;
44:
45:

Line 551: from cn_acc_period_statuses_v r1

547: AND spq.period_id = p.period_id)
548: -- bug 2460926, clku, check if all the open period ends before the specified start_date
549: -- 2479359, Nvl(x_start_date, pa.start_date) added to deal with NULL x_start_date
550: AND EXISTS(select r1.end_date
551: from cn_acc_period_statuses_v r1
552: where r1.end_date >= Nvl(x_start_date, pa.start_date)
553: AND r1.org_id = pa.org_id)
554: ;
555:

Line 659: from cn_acc_period_statuses_v r1

655: FROM cn_srp_period_quotas_all spq
656: WHERE spq.srp_quota_assign_id = qa.srp_quota_assign_id
657: AND spq.period_id = p.period_id)
658: AND EXISTS(select r1.end_date
659: from cn_acc_period_statuses_v r1
660: where r1.end_date > pa.start_date
661: AND r1.org_id = pa.org_id);
662:
663: --bugfix #2874991 starts

Line 735: ,cn_acc_period_statuses_v p

731: ,qa.org_id
732: FROM cn_srp_quota_assigns_all qa
733: ,cn_quotas_all q
734: ,cn_srp_plan_assigns_all pa
735: ,cn_acc_period_statuses_v p
736: -- bug fix 4042235
737: ,cn_period_statuses p2
738: ,cn_period_statuses p3
739:

Line 772: from cn_acc_period_statuses_v r1

768: AND pq.period_id = p.period_id)
769: -- bug 2460926, check if all the open period ends before the specified start_date
770:
771: AND EXISTS(select r1.end_date
772: from cn_acc_period_statuses_v r1
773: where r1.end_date > x_start_date
774: AND r1.org_id = pa.org_id)
775: ;
776: