eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PAY_GROUPS_ALL

Line 48: FROM cn_srp_pay_groups_all

44: x_loading_status := p_loading_status ;
45:
46: -- Check if already exist( duplicate assigned,unique key violation check)
47: SELECT COUNT(1) INTO l_dummy
48: FROM cn_srp_pay_groups_all
49: WHERE salesrep_id = p_salesrep_id
50: AND pay_group_id = p_pay_group_id
51: AND start_date = p_start_date
52: AND ( (end_date = p_end_date) OR

Line 208: FROM cn_srp_pay_groups_all

204: -- Check for overlapping assignments
205: --
206: SELECT count(1)
207: INTO l_count
208: FROM cn_srp_pay_groups_all
209: WHERE p_start_date between start_date AND Nvl(end_date, p_start_date)
210: AND salesrep_id = p_salesrep_id
211: AND org_id = p_org_id
212: AND srp_pay_group_id <> p_srp_pay_group_id;

Line 229: FROM cn_srp_pay_groups_all

225: END IF;
226:
227: SELECT count(1)
228: INTO l_count
229: FROM cn_srp_pay_groups_all
230: WHERE Nvl(p_end_date, l_null_date) between start_date
231: AND Nvl(end_date, Nvl(p_end_date, l_null_date))
232: AND salesrep_id = p_salesrep_id
233: AND org_id = p_org_id

Line 251: FROM cn_srp_pay_groups_all

247: END IF;
248:
249: SELECT count(1)
250: INTO l_count
251: FROM cn_srp_pay_groups_all
252: WHERE salesrep_id = p_salesrep_id
253: AND org_id = p_org_id
254: AND p_start_date <= start_date
255: AND Nvl(p_end_date, l_null_date) >= Nvl(end_date, l_null_date)

Line 912: from cn_srp_pay_groups_all

908: -- get the current object version number
909: select object_version_number, salesrep_id, start_date, end_date, lock_flag
910: into l_ovn_old, l_old_salesrep_id,
911: l_old_assignment_start_date, l_old_assignment_end_date, l_old_lock_flag
912: from cn_srp_pay_groups_all
913: where srp_pay_group_id = p_paygroup_assign_rec.srp_pay_group_id;
914:
915: IF l_ovn_old <> p_paygroup_assign_rec.object_version_number THEN
916: --

Line 1478: FROM cn_srp_pay_groups_all

1474: Close payee_check_curs;
1475:
1476: SELECT SRP_PAY_GROUP_ID
1477: INTO l_srp_pay_group_id
1478: FROM cn_srp_pay_groups_all
1479: WHERE pay_group_id = p_paygroup_assign_rec.pay_group_id
1480: AND start_date=p_paygroup_assign_rec.assignment_start_date
1481: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1482: end_date IS NULL)

Line 1485: SELECT COUNT(1) INTO l_count from cn_srp_pay_groups_all

1481: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1482: end_date IS NULL)
1483: AND salesrep_id =p_paygroup_assign_rec.salesrep_id;
1484:
1485: SELECT COUNT(1) INTO l_count from cn_srp_pay_groups_all
1486: WHERE srp_pay_group_id = l_srp_pay_group_id
1487: AND salesrep_id = p_paygroup_assign_rec.salesrep_id
1488: AND pay_group_id= p_paygroup_assign_rec.pay_group_id
1489: AND org_id = p_paygroup_assign_rec.org_id

Line 1620: from cn_srp_pay_groups_all

1616: AND org_id = p_paygroup_assign_rec.org_id;
1617:
1618: CURSOR get_srp_pg(l_salesrep_id NUMBER) IS
1619: select pay_group_id,start_date,end_date
1620: from cn_srp_pay_groups_all
1621: where salesrep_id = l_salesrep_id
1622: AND org_id = p_paygroup_assign_rec.org_id;
1623:
1624:

Line 1666: FROM cn_srp_pay_groups_all

1662:
1663: -- if made it here, then OK to delete
1664: SELECT SRP_PAY_GROUP_ID
1665: INTO l_srp_pay_group_id
1666: FROM cn_srp_pay_groups_all
1667: WHERE pay_group_id = p_paygroup_assign_rec.pay_group_id
1668: AND start_date=p_paygroup_assign_rec.assignment_start_date
1669: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1670: end_date IS NULL)

Line 1673: DELETE FROM cn_srp_pay_groups_all

1669: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1670: end_date IS NULL)
1671: AND salesrep_id =p_paygroup_assign_rec.salesrep_id;
1672:
1673: DELETE FROM cn_srp_pay_groups_all
1674: WHERE srp_pay_group_id = l_srp_pay_group_id;
1675:
1676: -- raise business event
1677: l_paygroup_assign_rec.srp_pay_group_id := l_srp_pay_group_id;

Line 1684: FROM cn_srp_pay_groups_all

1680: p_paygroup_assign_rec => l_paygroup_assign_rec);
1681:
1682: SELECT count (*), min(start_date),nvl(max(end_date),l_null_date) end_date
1683: INTO l_count,l_start_date,l_end_date
1684: FROM cn_srp_pay_groups_all
1685: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
1686: AND org_id = p_paygroup_assign_rec.org_id;
1687:
1688: --Modified for bug fix 3137894.

Line 1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp

1893: select spp.start_date, spp.end_date, spp.salesrep_id,
1894: spp.lock_flag,cpp.pay_group_id, spp.org_id
1895: into l_start_date, l_end_date, l_salesrep_id,
1896: l_lock_flag,l_pay_group_id, l_org_id
1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp
1898: where spp.role_pay_group_id = p_role_pay_group_id
1899: AND spp.salesrep_id = l_salesrep_id
1900: AND cpp.pay_group_id = spp.pay_group_id
1901: AND Greatest(spp.start_date, l_srp_start_date) <=

Line 1930: Update cn_srp_pay_groups_all

1926:
1927: IF l_count > 0
1928: THEN
1929: -- Making it a direct assignment if paysheets exist - for Bug 5557049.
1930: Update cn_srp_pay_groups_all
1931: set role_pay_group_id = null
1932: where role_pay_group_id = p_role_pay_group_id
1933: and salesrep_id = l_salesrep_id
1934: and org_id = l_org_id;