APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTA_RULE_UPLIFTS

Line 2142: FROM cn_quota_rule_uplifts qru,

2138: --Added by hanaraya for bug 6505174
2139: CURSOR uplift_curs(p_quota_id cn_quotas.quota_id%TYPE, p_start_date cn_quotas.start_date%TYPE, p_end_date cn_quotas.end_date%TYPE)
2140: IS
2141: SELECT COUNT (1)
2142: FROM cn_quota_rule_uplifts qru,
2143: cn_quota_rules qr
2144: WHERE qr.quota_id = p_quota_id
2145: AND qr.quota_rule_id = qru.quota_rule_id
2146: AND (qru.start_date < p_start_date OR (p_end_date IS NOT NULL AND qru.end_date IS NULL) OR qru.end_date > p_end_date);