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 614: FROM cn_srp_plan_assigns

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

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