APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTA_RULE_UPLIFTS

Line 2166: FROM cn_quota_rule_uplifts qru,

2162: --Added by hanaraya for bug 6505174
2163: 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)
2164: IS
2165: SELECT COUNT (1)
2166: FROM cn_quota_rule_uplifts qru,
2167: cn_quota_rules qr
2168: WHERE qr.quota_id = p_quota_id
2169: AND qr.quota_rule_id = qru.quota_rule_id
2170: 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);