APPS.PAY_EVG_BUS dependencies on PAY_EVENT_GROUPS

Line 29: , pay_event_groups evg

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_event_groups evg
30: where evg.event_group_id = p_event_group_id
31: and pbg.business_group_id = evg.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_event_groups evg

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_event_groups evg
90: where evg.event_group_id = p_event_group_id
91: and pbg.business_group_id (+) = evg.business_group_id;
92: --
93: -- Declare local variables

Line 258: from pay_event_groups peg

254: l_proc varchar2(72) := g_package||'chk_unique_key';
255: --
256: cursor C1 is
257: select 'Y'
258: from pay_event_groups peg
259: where peg.event_group_name = p_rec.event_group_name
260: and ( nvl(peg.business_group_id,p_rec.business_group_id) = p_rec.business_group_id)
261: and ( nvl(peg.legislation_code,p_rec.legislation_code)= p_rec.legislation_code);
262: --

Line 273: pay_evg_shd.constraint_error('PAY_EVENT_GROUPS_UK1');

269: if C1%found then
270: hr_utility.set_location(l_proc, 3);
271: -- row is not unique
272: close C1;
273: pay_evg_shd.constraint_error('PAY_EVENT_GROUPS_UK1');
274: end if;
275: close C1;
276: --
277: hr_utility.set_location('Leaving:'|| l_proc, 10);