APPS.CN_PERIODS_API dependencies on CN_SRP_PAYEE_ASSIGNS

Line 632: from cn_srp_payee_assigns spay, cn_srp_plan_assigns spa,

628: WHERE period_id = l_period_id;
629:
630: CURSOR srp_payee_info(l_salesrep_id in number) IS
631: SELECT spay.quota_id, spay.start_date, spay.end_date, spa.comp_plan_id
632: from cn_srp_payee_assigns spay, cn_srp_plan_assigns spa,
633: cn_srp_quota_assigns sqa
634: where spay.payee_id = l_salesrep_id
635: and (spay.end_date IS NULL OR spay.end_date >= l_start_date)
636: AND spay.start_date <= l_end_date