APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_PAY_GROUPS_ALL

Line 151: FROM cn_pay_groups_all

147: --
148:
149: SELECT start_date, end_date
150: INTO l_pp_start_date, l_pp_end_date
151: FROM cn_pay_groups_all
152: WHERE pay_group_id = p_pay_group_id;
153: IF ( (
154: ( l_pp_start_date IS NOT NULL) AND ( l_pp_end_date IS NOT NULL)
155: AND(

Line 185: FROM cn_pay_groups_all

181: -- pay group.
182: --
183: SELECT COUNT(1)
184: INTO l_count
185: FROM cn_pay_groups_all
186: WHERE (( p_start_date NOT BETWEEN start_date AND end_date )
187: OR (p_end_date NOT BETWEEN start_date AND end_date))
188: AND pay_group_id = p_pay_group_id;
189:

Line 703: from cn_pay_groups_all

699: -- after paygroup is assigned
700:
701: select name
702: into l_pay_group_name
703: from cn_pay_groups_all
704: where pay_group_id = p_paygroup_assign_rec.pay_group_id;
705:
706: cn_mark_events_pkg.mark_event_srp_pay_group
707: ('CHANGE_SRP_PAY_GROUP', -- event name

Line 1260: from cn_pay_groups_all

1256: -- range change as a result of the paygroup daterange change
1257:
1258: select name
1259: into l_pay_group_name
1260: from cn_pay_groups_all
1261: where pay_group_id = p_paygroup_assign_rec.pay_group_id;
1262:
1263: cn_mark_events_pkg.mark_event_srp_pay_group
1264: ('CHANGE_SRP_PAY_GROUP_DATE', -- event name

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) <=