APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_ROLES

Line 75: from cn_srp_roles

71:
72: -- get srp role assignment start and end dates
73: select start_date, end_date, salesrep_id
74: into l_srp_role_start_date, l_srp_role_end_date, l_salesrep_id
75: from cn_srp_roles
76: where srp_role_id = p_srp_role_id
77: and org_id = l_org_id;
78:
79: -- get intersection between srp_role and role_pay_group dates

Line 709: FROM cn_srp_roles

705: x_loading_status OUT NOCOPY VARCHAR2 ) IS
706:
707: CURSOR l_cur IS
708: SELECT srp_role_id
709: FROM cn_srp_roles
710: WHERE role_id = p_role_id and salesrep_id= p_salesrep_id and org_id=p_org_id;
711:
712: l_rec l_cur%ROWTYPE;
713:

Line 786: FROM cn_srp_roles

782: --CN_Srp_PayGroup_PUB.PayGroup_assign_rec
783:
784: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
785: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
786: FROM cn_srp_roles
787: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
788:
789: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
790: SELECT role_plan_id

Line 805: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

801: FROM cn_srp_plan_assigns
802: WHERE role_id = p_role_id
803: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
804:
805: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
806: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
807: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
808:
809:

Line 807: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;

803: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
804:
805: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
806: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
807: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
808:
809:
810: l_role_pg_rec role_pay_groups_rec_type;
811: l_rec l_srp_cur%ROWTYPE;

Line 1161: FROM cn_srp_roles

1157:
1158:
1159: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
1160: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
1161: FROM cn_srp_roles
1162: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1163:
1164: --Changed the cursor to fetch role_plans for the role_id passed
1165:

Line 1188: FROM cn_srp_roles

1184:
1185:
1186: CURSOR get_salesreps(l_role_id NUMBER,l_pay_group_id cn_pay_groups.pay_group_id%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
1187: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1188: FROM cn_srp_roles
1189: WHERE role_id = l_role_id
1190: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)
1191: and org_id=l_org_id;
1192: