DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_QUOTA_ASSIGNS

Line 621: from cn_quota_assigns qa, cn_quotas q

617: AND start_date <= l_start_date AND end_date >= l_end_date;
618:
619: CURSOR get_credit_types(l_comp_plan_id IN NUMBER) IS
620: select distinct q.credit_type_id
621: from cn_quota_assigns qa, cn_quotas q
622: where qa.comp_plan_id = l_comp_plan_id
623: and qa.quota_id = q.quota_id;
624:
625: CURSOR get_pd_info(l_period_id IN NUMBER) IS