APPS.PER_ASG_BUS2 dependencies on PAY_LEGISLATION_RULES

Line 3818: cursor csr_pay_legislation_rules is

3814: select legislation_code
3815: from per_business_groups_perf
3816: where business_group_id = p_business_group_id;
3817: --
3818: cursor csr_pay_legislation_rules is
3819: select null
3820: from pay_legislation_rules
3821: where legislation_code = l_legislation_code
3822: and rule_type = 'TAX_UNIT'

Line 3820: from pay_legislation_rules

3816: where business_group_id = p_business_group_id;
3817: --
3818: cursor csr_pay_legislation_rules is
3819: select null
3820: from pay_legislation_rules
3821: where legislation_code = l_legislation_code
3822: and rule_type = 'TAX_UNIT'
3823: and rule_mode = 'Y';
3824: --

Line 3915: open csr_pay_legislation_rules;

3911: fetch csr_bg into l_legislation_code;
3912: close csr_bg;
3913: --
3914: hr_utility.set_location(l_proc, 55);
3915: open csr_pay_legislation_rules;
3916: fetch csr_pay_legislation_rules into l_exists;
3917: if csr_pay_legislation_rules%found then
3918: close csr_pay_legislation_rules;
3919: if l_legislation_code = 'US' then

Line 3916: fetch csr_pay_legislation_rules into l_exists;

3912: close csr_bg;
3913: --
3914: hr_utility.set_location(l_proc, 55);
3915: open csr_pay_legislation_rules;
3916: fetch csr_pay_legislation_rules into l_exists;
3917: if csr_pay_legislation_rules%found then
3918: close csr_pay_legislation_rules;
3919: if l_legislation_code = 'US' then
3920: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');

Line 3917: if csr_pay_legislation_rules%found then

3913: --
3914: hr_utility.set_location(l_proc, 55);
3915: open csr_pay_legislation_rules;
3916: fetch csr_pay_legislation_rules into l_exists;
3917: if csr_pay_legislation_rules%found then
3918: close csr_pay_legislation_rules;
3919: if l_legislation_code = 'US' then
3920: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');
3921: else

Line 3918: close csr_pay_legislation_rules;

3914: hr_utility.set_location(l_proc, 55);
3915: open csr_pay_legislation_rules;
3916: fetch csr_pay_legislation_rules into l_exists;
3917: if csr_pay_legislation_rules%found then
3918: close csr_pay_legislation_rules;
3919: if l_legislation_code = 'US' then
3920: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');
3921: else
3922: open csr_tax_unit_message('HR_INV_LEG_ENT_'||l_legislation_code);

Line 3936: close csr_pay_legislation_rules;

3932: hr_multi_message.add
3933: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3934: );
3935: else
3936: close csr_pay_legislation_rules;
3937: end if;
3938: hr_utility.set_location(l_proc, 65);
3939: end if;
3940: end if;