DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_QUOTA_ASSIGNS

Line 625: from cn_quota_assigns qa, cn_quotas q

621: AND nvl(end_date,l_null_date) >= l_start_date;
622:
623: CURSOR get_credit_types(l_comp_plan_id IN NUMBER) IS
624: select distinct q.credit_type_id
625: from cn_quota_assigns qa, cn_quotas q
626: where qa.comp_plan_id = l_comp_plan_id
627: and qa.quota_id = q.quota_id;
628:
629: CURSOR get_pd_info(l_period_id IN NUMBER) IS