APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SALESREPS

Line 65: l_salesrep_name cn_salesreps.name%TYPE;

61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
64: l_pay_group_id NUMBER;
65: l_salesrep_name cn_salesreps.name%TYPE;
66: l_role_name jtf_rs_roles_tl.role_name%TYPE;
67:
68: BEGIN
69: -- get start_date, end_date org_id and pay_group_id from role_pay_groups

Line 97: from cn_salesreps

93:
94: -- get resource start and end dates
95: select name, start_date_active, end_date_active
96: into l_salesrep_name, l_res_start_date, l_res_end_date
97: from cn_salesreps
98: where salesrep_id = l_salesrep_id
99: and org_id = l_org_id;
100:
101: -- get intersection with resource start and end dates

Line 724: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

720: -- --------------------------------------------------------------------------*
721: PROCEDURE srp_plan_assignment_for_delete
722: (p_role_id IN cn_roles.role_id%TYPE,
723: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
724: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
725: p_org_id IN cn_salesreps.org_id%TYPE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: p_loading_status IN VARCHAR2,
728: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 725: p_org_id IN cn_salesreps.org_id%TYPE,

721: PROCEDURE srp_plan_assignment_for_delete
722: (p_role_id IN cn_roles.role_id%TYPE,
723: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
724: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
725: p_org_id IN cn_salesreps.org_id%TYPE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: p_loading_status IN VARCHAR2,
728: x_loading_status OUT NOCOPY VARCHAR2 ) IS
729:

Line 807: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS

803: l_count NUMBER;
804:
805: --CN_Srp_PayGroup_PUB.PayGroup_assign_rec
806:
807: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
808:
809: /*
810: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
811: FROM cn_srp_roles

Line 1209: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS

1205: l_start_date DATE;
1206: l_end_date DATE;
1207:
1208:
1209: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
1210: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
1211: FROM cn_srp_roles
1212: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1213: