APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SALESREPS

Line 75: FROM cn_salesreps

71: -- cn_srp_periods in order to create cn_srp_period_quotas. It's also a
72: -- reasonable business requirement
73: SELECT start_date_active, end_date_active
74: INTO l_srp_start_date, l_srp_end_date
75: FROM cn_salesreps
76: WHERE salesrep_id = p_salesrep_id
77: AND org_id = p_org_id;
78:
79: IF l_srp_start_date IS NULL THEN

Line 380: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

376: -- --------------------------------------------------------------------------*
377: PROCEDURE srp_plan_assignment_for_delete
378: (p_role_id IN cn_roles.role_id%TYPE,
379: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
380: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
381: p_org_id IN cn_salesreps.org_id%TYPE,
382: x_return_status OUT NOCOPY VARCHAR2,
383: p_loading_status IN VARCHAR2,
384: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 381: p_org_id IN cn_salesreps.org_id%TYPE,

377: PROCEDURE srp_plan_assignment_for_delete
378: (p_role_id IN cn_roles.role_id%TYPE,
379: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
380: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
381: p_org_id IN cn_salesreps.org_id%TYPE,
382: x_return_status OUT NOCOPY VARCHAR2,
383: p_loading_status IN VARCHAR2,
384: x_loading_status OUT NOCOPY VARCHAR2 ) IS
385:

Line 499: l_employee_number cn_salesreps.employee_number%TYPE;

495: l_role_id cn_roles.role_id%TYPE;
496: l_loading_status VARCHAR2(2000);
497: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
498: l_status VARCHAR2(30);
499: l_employee_number cn_salesreps.employee_number%TYPE;
500: l_employee_name cn_salesreps.name%TYPE;
501: l_pay_group_name cn_pay_groups.name%TYPE;
502:
503: CURSOR get_roles (p_salesrep_id NUMBER) IS

Line 500: l_employee_name cn_salesreps.name%TYPE;

496: l_loading_status VARCHAR2(2000);
497: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
498: l_status VARCHAR2(30);
499: l_employee_number cn_salesreps.employee_number%TYPE;
500: l_employee_name cn_salesreps.name%TYPE;
501: l_pay_group_name cn_pay_groups.name%TYPE;
502:
503: CURSOR get_roles (p_salesrep_id NUMBER) IS
504: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date

Line 570: FROM cn_salesreps

566: x_status => l_status );
567:
568: SELECT name, employee_number
569: INTO l_employee_name, l_employee_number
570: FROM cn_salesreps
571: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
572: AND org_id = p_paygroup_assign_rec.org_id;
573:
574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 875: l_employee_number cn_salesreps.employee_number%TYPE;

871: l_old_assignment_end_date DATE;
872: l_old_salesrep_id NUMBER;
873: l_old_lock_flag VARCHAR2(1);
874: l_status VARCHAR2(30);
875: l_employee_number cn_salesreps.employee_number%TYPE;
876: l_employee_name cn_salesreps.name%TYPE;
877: l_pay_group_name cn_pay_groups.name%TYPE;
878: l_dummy NUMBER;
879: l_srp_role_id NUMBER;

Line 876: l_employee_name cn_salesreps.name%TYPE;

872: l_old_salesrep_id NUMBER;
873: l_old_lock_flag VARCHAR2(1);
874: l_status VARCHAR2(30);
875: l_employee_number cn_salesreps.employee_number%TYPE;
876: l_employee_name cn_salesreps.name%TYPE;
877: l_pay_group_name cn_pay_groups.name%TYPE;
878: l_dummy NUMBER;
879: l_srp_role_id NUMBER;
880:

Line 982: FROM cn_salesreps

978: x_status => l_status );
979:
980: SELECT name, employee_number
981: INTO l_employee_name, l_employee_number
982: FROM cn_salesreps
983: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
984: AND org_id = p_paygroup_assign_rec.org_id;
985:
986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1601: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE) IS

1597: FROM cn_srp_roles
1598: WHERE role_id = l_role_id
1599: AND org_id = p_paygroup_assign_rec.org_id;
1600:
1601: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE) IS
1602: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date
1603: FROM cn_srp_roles
1604: WHERE salesrep_id = p_salesrep_id
1605: AND org_id = p_paygroup_assign_rec.org_id;

Line 1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

1848: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1849: l_loading_status VARCHAR2(2000);
1850:
1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1853: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;