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: l_source_id cn_salesreps.source_id%TYPE;

Line 1341: from cn_srp_roles

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

Line 1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;

1513: l_pay_group_name_new cn_pay_groups.name%TYPE;
1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;

Line 1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;

1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;
1522: l_source_id_new cn_salesreps.source_id%TYPE;

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

1530: from cn_srp_pay_groups sp
1531: where salesrep_id = l_salesrep_id_old
1532: AND role_pay_group_id = p_role_pay_group_id
1533: AND NOT EXISTS
1534: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp
1535: Where salesrep_id = l_salesrep_id_old
1536: AND role_pay_group_id = p_role_pay_group_id
1537: AND sr.role_id = rp.role_id
1538: AND sr.org_id = rp.org_id

Line 1580: FROM cn_srp_roles

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

Line 1652: FROM cn_srp_roles

1648: END IF;
1649:
1650: SELECT salesrep_id, start_date, end_date
1651: INTO l_salesrep_id_new, l_srp_start_date_new, l_srp_end_date_new
1652: FROM cn_srp_roles
1653: WHERE srp_role_id = p_srp_role_id
1654: AND org_id = l_org_id;
1655:
1656: SELECT employee_number, type,source_id