APPS.PAY_GBE_BUS dependencies on PAY_GROSSUP_BAL_EXCLUSIONS

Line 27: -- pay_grossup_bal_exclusions and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- pay_grossup_bal_exclusions and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: -- cursor csr_sec_grp is

Line 34: -- , pay_grossup_bal_exclusions gbe

30: -- Remove this comment when the edit has been completed.
31: -- cursor csr_sec_grp is
32: -- select pbg.security_group_id
33: -- from per_business_groups pbg
34: -- , pay_grossup_bal_exclusions gbe
35: -- , EDIT_HERE table_name(s) 333
36: -- where gbe.grossup_balances_id = p_grossup_balances_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 93: -- pay_grossup_bal_exclusions and PER_BUSINESS_GROUPS

89: --
90: -- Declare cursor
91: --
92: -- EDIT_HERE In the following cursor statement add join(s) between
93: -- pay_grossup_bal_exclusions and PER_BUSINESS_GROUPS
94: -- so that the legislation_code for
95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: -- cursor csr_leg_code is

Line 100: -- , pay_grossup_bal_exclusions gbe

96: -- Remove this comment when the edit has been completed.
97: -- cursor csr_leg_code is
98: -- select pbg.legislation_code
99: -- from per_business_groups pbg
100: -- , pay_grossup_bal_exclusions gbe
101: -- , EDIT_HERE table_name(s) 333
102: -- where gbe.grossup_balances_id = p_grossup_balances_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
104: --

Line 275: From pay_grossup_bal_exclusions

271: l_api_updating boolean;
272: --
273: Cursor C1_upd is
274: Select 'Y'
275: From pay_grossup_bal_exclusions
276: Where not
277: ((start_date < p_start_date
278: and nvl(end_date, hr_general.END_OF_TIME) < p_start_date)
279: OR

Line 374: From pay_grossup_bal_exclusions

370: l_proc varchar2(72) := g_package||'chk_ins_dates';
371: --
372: Cursor C1_ins is
373: Select 'Y'
374: From pay_grossup_bal_exclusions
375: Where not
376: ((start_date < p_start_date
377: and nvl(end_date, hr_general.END_OF_TIME) < p_start_date)
378: OR

Line 558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');

554: if C1%notfound then
555: hr_utility.set_location(l_proc, 3);
556: close C1;
557: -- raise error as FK does not relate to PK in pay_balance_types
558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');
559: end if;
560: close C1;
561: hr_utility.set_location('Leaving:'|| l_proc, 10);
562: end chk_bal_type_id;

Line 604: from pay_grossup_bal_exclusions gbe

600: l_proc varchar2(72) := g_package||'chk_unique_key';
601: --
602: cursor C1 is
603: select 'Y'
604: from pay_grossup_bal_exclusions gbe
605: where gbe.balance_type_id = p_balance_type_id
606: and gbe.start_date = p_start_date
607: and gbe.end_date = p_end_date
608: and gbe.source_type = p_source_type

Line 621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');

617: if C1%found then
618: hr_utility.set_location(l_proc, 3);
619: -- row is not unique
620: close C1;
621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');
622: end if;
623: close C1;
624: --
625: hr_utility.set_location('Leaving:'|| l_proc, 10);