eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PERIODS_API dependencies on CN_SRP_PLAN_ASSIGNS

Line 615: FROM cn_srp_plan_assigns

611:
612: CURSOR srp_plan_info(l_salesrep_id IN NUMBER, l_start_date IN DATE, l_end_date IN DATE) IS
613: SELECT srp_plan_assign_id, role_id, comp_plan_id,
614: start_date, end_date, salesrep_id
615: FROM cn_srp_plan_assigns
616: WHERE salesrep_id = l_salesrep_id
617: AND role_id IS NOT null
618: --AND start_date <= l_start_date AND end_date >= l_end_date
619: AND (start_date <= l_start_date OR

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