APPS.CN_PAYGROUP_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 700: FROM cn_srp_plan_assigns

696: p_org_id NUMBER) IS
697: SELECT comp_plan_id,
698: start_date,
699: end_date
700: FROM cn_srp_plan_assigns
701: WHERE role_id = p_role_id
702: AND salesrep_id = p_salesrep_id
703: AND org_id = p_org_id;
704:

Line 1212: -- mop up changes in cn_srp_plan_assigns for this rep

1208:
1209: -- if reps are assigned with null end date, then propogate changes to
1210: -- their srp_plan_assigns (fix for bug 4529601)
1211: FOR s IN get_affected_reps LOOP
1212: -- mop up changes in cn_srp_plan_assigns for this rep
1213: cn_srp_plan_assigns_pvt.update_srp_plan_assigns
1214: (p_api_version => 1.0,
1215: x_return_status => x_return_status,
1216: x_msg_count => x_msg_count,

Line 1213: cn_srp_plan_assigns_pvt.update_srp_plan_assigns

1209: -- if reps are assigned with null end date, then propogate changes to
1210: -- their srp_plan_assigns (fix for bug 4529601)
1211: FOR s IN get_affected_reps LOOP
1212: -- mop up changes in cn_srp_plan_assigns for this rep
1213: cn_srp_plan_assigns_pvt.update_srp_plan_assigns
1214: (p_api_version => 1.0,
1215: x_return_status => x_return_status,
1216: x_msg_count => x_msg_count,
1217: x_msg_data => x_msg_data,