APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_ROLES

Line 388: FROM cn_srp_roles

384: x_loading_status OUT NOCOPY VARCHAR2 ) IS
385:
386: CURSOR l_cur IS
387: SELECT srp_role_id
388: FROM cn_srp_roles
389: WHERE role_id = p_role_id
390: and salesrep_id =p_salesrep_id
391: AND org_id = p_org_id;
392:

Line 505: FROM cn_srp_roles

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
505: FROM cn_srp_roles
506: WHERE salesrep_id = p_salesrep_id
507: AND org_id = p_paygroup_assign_rec.org_id;
508:
509: CURSOR get_role_plans(p_role_id NUMBER) IS

Line 831: FROM cn_srp_roles

827: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
828:
829: CURSOR get_roles (p_salesrep_id NUMBER) IS
830: SELECT role_id,srp_role_id,start_date, nvl(end_date,l_null_date) end_date
831: FROM cn_srp_roles
832: WHERE salesrep_id = p_salesrep_id
833: AND org_id = p_paygroup_assign_rec.org_id;
834:
835: CURSOR get_role_plans(p_role_id NUMBER) IS

Line 854: select srp_role_id from cn_srp_roles where

850: AND org_id = p_paygroup_assign_rec.org_id;
851:
852: -- clku
853: CURSOR payee_check_curs(l_salesrep_id NUMBER) IS
854: select srp_role_id from cn_srp_roles where
855: salesrep_id = l_salesrep_id
856: and role_id = 54
857: AND org_id = p_paygroup_assign_rec.org_id;
858:

Line 1387: select srp_role_id from cn_srp_roles where

1383: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1384:
1385: -- clku
1386: CURSOR payee_check_curs(l_salesrep_id NUMBER) IS
1387: select srp_role_id from cn_srp_roles where
1388: salesrep_id = l_salesrep_id
1389: and role_id = 54
1390: AND org_id = p_paygroup_assign_rec.org_id;
1391:

Line 1597: FROM cn_srp_roles

1593: AND org_id = p_paygroup_assign_rec.org_id;
1594:
1595: CURSOR get_salesreps(l_role_id NUMBER) IS
1596: SELECT srp_role_id,salesrep_id
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

Line 1603: FROM cn_srp_roles

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;
1606:
1607: CURSOR get_plan_assigns

Line 1856: l_srp_start_date cn_srp_roles.start_date%TYPE;

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;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;

Line 1874: from cn_srp_roles

1870: WHERE role_pay_group_id = p_role_pay_group_id;
1871:
1872: select salesrep_id, start_date, end_date
1873: into l_salesrep_id, l_srp_start_date, l_srp_end_date
1874: from cn_srp_roles
1875: where srp_role_id = p_srp_role_id
1876: AND org_id = l_org_id; -- vensrini
1877:
1878: -- make sure dates overlap