APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_SRP_PAY_GROUPS_ALL

Line 701: FROM cn_srp_pay_groups_all

697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id
701: FROM cn_srp_pay_groups_all
702: WHERE salesrep_id = c_salesrep_id
703: AND pay_group_id = c_pay_group_id
704: AND trunc(start_date) = trunc(c_start_date)
705: AND trunc(nvl(end_date, l_null_date)) =

Line 1369: from cn_srp_pay_groups_all

1365: IF l_start_date IS NOT NULL AND l_end_date IS NOT NULL THEN
1366:
1367: select count(*)
1368: into l_count
1369: from cn_srp_pay_groups_all
1370: where salesrep_id = l_salesrep_id
1371: AND org_id = l_org_id
1372: and ((l_start_date between start_date and nvl(end_date,l_null_date))
1373: or (nvl(l_end_date,l_null_date) between

Line 1586: FROM cn_srp_pay_groups_all

1582: AND org_id = l_org_id;
1583:
1584: SELECT count(*)
1585: INTO l_count
1586: FROM cn_srp_pay_groups_all
1587: WHERE salesrep_id = l_salesrep_id_old
1588: AND role_pay_group_id = p_role_pay_group_id;
1589:
1590: IF (l_count <> 0)

Line 1674: FROM cn_srp_pay_groups_all

1670: WHERE pay_group_id = l_pay_group_id_new;
1671:
1672: SELECT count(*)
1673: INTO l_count_srp_pay_group
1674: FROM cn_srp_pay_groups_all
1675: WHERE salesrep_id=l_salesrep_id_old
1676: AND org_id = l_org_id
1677: AND ((l_start_date_old between start_date and nvl(end_date,l_null_date))
1678: OR (l_end_date_old between start_date and nvl(end_date,l_null_date)));

Line 1745: FROM cn_srp_pay_groups_all

1741: THEN
1742:
1743: SELECT count(*)
1744: INTO l_count_srp_pay_group
1745: FROM cn_srp_pay_groups_all
1746: WHERE salesrep_id=l_salesrep_id_old
1747: AND org_id = l_org_id
1748: AND ((l_start_date_new between start_date and nvl(end_date,l_null_date))
1749: OR (l_end_date_new between start_date and nvl(end_date,l_null_date)));