APPS.CN_PERIODS_API dependencies on CN_SRP_PAYEE_ASSIGNS

Line 636: from cn_srp_payee_assigns spay, cn_srp_plan_assigns spa,

632: WHERE period_id = l_period_id;
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