DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_SRP_QUOTA_ASSIGNS

Line 637: cn_srp_quota_assigns sqa

633:
634: CURSOR srp_payee_info(l_salesrep_id in number) IS
635: SELECT spay.quota_id, spay.start_date, spay.end_date, spa.comp_plan_id
636: from cn_srp_payee_assigns spay, cn_srp_plan_assigns spa,
637: cn_srp_quota_assigns sqa
638: where spay.payee_id = l_salesrep_id
639: and (spay.end_date IS NULL OR spay.end_date >= l_start_date)
640: AND spay.start_date <= l_end_date
641: and spay.srp_quota_assign_id = sqa.srp_quota_assign_id