DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_SRP_QUOTA_ASSIGNS

Line 633: cn_srp_quota_assigns sqa

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
637: and spay.srp_quota_assign_id = sqa.srp_quota_assign_id