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 1368: from cn_srp_pay_groups_all

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

Line 1582: FROM cn_srp_pay_groups_all

1578: AND org_id = l_org_id;
1579:
1580: SELECT count(*)
1581: INTO l_count
1582: FROM cn_srp_pay_groups_all
1583: WHERE salesrep_id = l_salesrep_id_old
1584: AND role_pay_group_id = p_role_pay_group_id;
1585:
1586: IF (l_count <> 0)

Line 1667: FROM cn_srp_pay_groups_all

1663: WHERE pay_group_id = l_pay_group_id_new;
1664:
1665: SELECT count(*)
1666: INTO l_count_srp_pay_group
1667: FROM cn_srp_pay_groups_all
1668: WHERE salesrep_id=l_salesrep_id_old
1669: AND org_id = l_org_id
1670: AND ((l_start_date_old between start_date and nvl(end_date,l_null_date))
1671: OR (l_end_date_old between start_date and nvl(end_date,l_null_date)));

Line 1737: FROM cn_srp_pay_groups_all

1733: THEN
1734:
1735: SELECT count(*)
1736: INTO l_count_srp_pay_group
1737: FROM cn_srp_pay_groups_all
1738: WHERE salesrep_id=l_salesrep_id_old
1739: AND org_id = l_org_id
1740: AND ((l_start_date_new between start_date and nvl(end_date,l_null_date))
1741: OR (l_end_date_new between start_date and nvl(end_date,l_null_date)));