APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_ROLE_PAY_GROUPS

Line 1869: FROM cn_role_pay_groups

1865: BEGIN
1866: -- vensrini. Fix to delete role assignments when resource is in two orgs.
1867: SELECT org_id
1868: INTO l_org_id
1869: FROM cn_role_pay_groups
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

Line 1880: FROM cn_role_pay_groups

1876: AND org_id = l_org_id; -- vensrini
1877:
1878: -- make sure dates overlap
1879: SELECT COUNT(1) INTO l_count
1880: FROM cn_role_pay_groups
1881: WHERE role_pay_group_id = p_role_pay_group_id
1882: AND Greatest(l_srp_start_date, start_date) <=
1883: Least(Nvl(l_srp_end_date, l_null_date),
1884: Nvl(end_date, l_null_date));