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_GET_COMM_SUMM_DATA_PVT dependencies on CN_ROLES

Line 327: cn_roles r,

323: cp.name plan_name,
324: assign.start_date start_date,
325: assign.end_date end_date
326: FROM cn_srp_plan_assigns assign,
327: cn_roles r,
328: cn_comp_plans cp
329: WHERE l_year_start_date <= nvl(assign.end_date, l_year_start_date)
330: AND l_period_end_date >= assign.start_date
331: AND assign.role_id = r.role_id

Line 605: cn_roles r,

601: assign.salesrep_id salesrep_id,
602: nvl(inv_ptd.earnings,0) ptd_earnings,
603: nvl(inv_ytd.earnings,0) ytd_earnings
604: FROM cn_srp_plan_assigns assign,
605: cn_roles r,
606: cn_comp_plans cp,
607: (select spa.srp_plan_assign_id srp_plan_assign_id,
608: nvl(sum(balance2_dtd),0) earnings
609: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

Line 720: cn_roles r,

716: assign.end_date end_date,
717: assign.salesrep_id salesrep_id,
718: nvl(inv.earnings,0) earnings
719: FROM cn_srp_plan_assigns assign,
720: cn_roles r,
721: cn_comp_plans cp,
722: (select spa.srp_plan_assign_id srp_plan_assign_id,
723: nvl(sum(balance2_dtd),0) earnings
724: from cn_srp_periods sp, cn_srp_plan_assigns spa, cn_quotas_all q

Line 812: cn_roles r,

808: cursor cur_srp_plan_assign_id
809: is
810: SELECT assign.srp_plan_assign_id
811: FROM cn_srp_plan_assigns assign,
812: cn_roles r,
813: cn_comp_plans cp
814: WHERE l_year_start_date <= nvl(assign.end_date, l_year_start_date)
815: AND l_period_end_date >= assign.start_date
816: AND assign.role_id = r.role_id

Line 908: cn_roles r,

904: c_org_id NUMBER)
905: is
906: SELECT assign.srp_plan_assign_id
907: FROM cn_srp_plan_assigns assign,
908: cn_roles r,
909: cn_comp_plans cp
910: WHERE c_year_start_date <= nvl(assign.end_date, c_year_start_date)
911: AND c_period_end_date >= assign.start_date
912: AND assign.role_id = r.role_id

Line 1036: cn_roles r,

1032: c_analyst_id NUMBER)
1033: is
1034: SELECT assign.srp_plan_assign_id
1035: FROM cn_srp_plan_assigns assign,
1036: cn_roles r,
1037: cn_comp_plans cp
1038: WHERE c_year_start_date <= nvl(assign.end_date, c_year_start_date)
1039: AND c_period_end_date >= assign.start_date
1040: AND assign.role_id = r.role_id

Line 1157: cn_roles r,

1153: assign.end_date end_date,
1154: q.quota_group_code quota_group_code
1155: FROM cn_srp_periods srp,
1156: cn_srp_plan_assigns assign,
1157: cn_roles r,
1158: cn_comp_plans cp,
1159: cn_payment_worksheets w,
1160: cn_quotas_all q
1161: WHERE assign.srp_plan_assign_id(+) = srp.srp_plan_assign_id