APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_SRP_ROLES

Line 66: from cn_srp_roles

62:
63: -- get srp role assignment start and end dates
64: select start_date, end_date, salesrep_id
65: into l_srp_role_start_date, l_srp_role_end_date, l_salesrep_id
66: from cn_srp_roles
67: where srp_role_id = p_srp_role_id
68: and org_id = l_org_id;
69:
70: -- get intersection between srp_role and role_pay_group dates

Line 1299: l_srp_start_date cn_srp_roles.start_date%TYPE;

1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;
1303:

Line 1340: from cn_srp_roles

1336: end if;
1337:
1338: select salesrep_id, start_date, end_date
1339: into l_salesrep_id, l_srp_start_date, l_srp_end_date
1340: from cn_srp_roles
1341: where srp_role_id = p_srp_role_id
1342: AND org_id = l_org_id;
1343:
1344: select employee_number, type

Line 1515: l_srp_start_date_new cn_srp_roles.start_date%TYPE;

1511: l_pay_group_name_new cn_pay_groups.name%TYPE;
1512: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1513: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1514: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1515: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1516: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1517: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1518: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1519:

Line 1516: l_srp_end_date_new cn_srp_roles.end_date%TYPE;

1512: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1513: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1514: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1515: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1516: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1517: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1518: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1519:
1520:

Line 1530: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp

1526: from cn_srp_pay_groups sp
1527: where salesrep_id = l_salesrep_id_old
1528: AND role_pay_group_id = p_role_pay_group_id
1529: AND NOT EXISTS
1530: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp
1531: Where salesrep_id = l_salesrep_id_old
1532: AND role_pay_group_id = p_role_pay_group_id
1533: AND sr.role_id = rp.role_id
1534: AND sr.org_id = rp.org_id

Line 1576: FROM cn_srp_roles

1572: end if;
1573:
1574: SELECT salesrep_id,role_id,start_date, end_date
1575: INTO l_salesrep_id_old,l_role_id_old,l_srp_start_date_new, l_srp_end_date_new
1576: FROM cn_srp_roles
1577: WHERE srp_role_id = p_srp_role_id
1578: AND org_id = l_org_id;
1579:
1580: SELECT count(*)

Line 1645: FROM cn_srp_roles

1641: END IF;
1642:
1643: SELECT salesrep_id, start_date, end_date
1644: INTO l_salesrep_id_new, l_srp_start_date_new, l_srp_end_date_new
1645: FROM cn_srp_roles
1646: WHERE srp_role_id = p_srp_role_id
1647: AND org_id = l_org_id;
1648:
1649: SELECT employee_number, type