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_COMMISSION_CALC_PVT dependencies on CN_COMP_PLANS

Line 129: FROM cn_comp_plans

125: AND csqa.srp_plan_assign_id = cspa.srp_plan_assign_id;
126:
127: CURSOR compplan_cr(p_comp_plan_id NUMBER) IS
128: SELECT count(*) valid_compplan_cnt
129: FROM cn_comp_plans
130: WHERE comp_plan_id = p_comp_plan_id
131: AND status_code = 'INCOMPLETE';
132:
133: CURSOR quotadetails_cr(p_salesrep_id NUMBER, p_revenueclass_id NUMBER, p_date DATE) IS

Line 164: and exists (select 1 from cn_comp_plans where status_code = 'COMPLETE' AND comp_plan_id = spa.comp_plan_id)

160: and rr.role_id = spa.role_id
161: and rr.role_resource_id = mem.group_member_id
162: and rr.role_resource_type = 'RS_GROUP_MEMBER'
163: and nvl(rr.delete_flag, 'N') <> 'Y'
164: and exists (select 1 from cn_comp_plans where status_code = 'COMPLETE' AND comp_plan_id = spa.comp_plan_id)
165: and rr.start_date_active <= p_date
166: and nvl(rr.end_date_active, p_date) >= p_date
167: and rr.start_date_active <= nvl(spa.end_date, p_date)
168: and nvl(rr.end_date_active, nvl(spa.end_date, p_date)) >= spa.start_date