APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SALESREPS

Line 94: from cn_salesreps

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

Line 701: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

697: -- --------------------------------------------------------------------------*
698: PROCEDURE srp_plan_assignment_for_delete
699: (p_role_id IN cn_roles.role_id%TYPE,
700: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
701: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
702: p_org_id IN cn_salesreps.org_id%TYPE,
703: x_return_status OUT NOCOPY VARCHAR2,
704: p_loading_status IN VARCHAR2,
705: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 702: p_org_id IN cn_salesreps.org_id%TYPE,

698: PROCEDURE srp_plan_assignment_for_delete
699: (p_role_id IN cn_roles.role_id%TYPE,
700: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
701: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
702: p_org_id IN cn_salesreps.org_id%TYPE,
703: x_return_status OUT NOCOPY VARCHAR2,
704: p_loading_status IN VARCHAR2,
705: x_loading_status OUT NOCOPY VARCHAR2 ) IS
706:

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

780: l_count NUMBER;
781:
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:

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

1155: l_start_date DATE;
1156: l_end_date DATE;
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: