[Home] [Help]
4017: , spq.quota_id
4018: , DECODE(acc.period_id, l_start_period_id, l_s_date, acc.start_date) start_date
4019: , DECODE(acc.period_id, l_end_period_id, NVL(l_e_date, acc.end_date), acc.end_date)
4020: end_date
4021: FROM cn_srp_quota_rules_all rule
4022: , cn_srp_period_quotas_all spq
4023: , cn_period_statuses_all acc
4024: , cn_srp_intel_periods_all intel
4025: WHERE rule.srp_quota_rule_id = p_srp_object_id --p_srp_quota_rule_id