APPS.PER_ASG_BUS2 dependencies on PAY_LEGISLATION_RULES

Line 3858: cursor csr_pay_legislation_rules is

3854: select legislation_code
3855: from per_business_groups_perf
3856: where business_group_id = p_business_group_id;
3857: --
3858: cursor csr_pay_legislation_rules is
3859: select null
3860: from pay_legislation_rules
3861: where legislation_code = l_legislation_code
3862: and rule_type = 'TAX_UNIT'

Line 3860: from pay_legislation_rules

3856: where business_group_id = p_business_group_id;
3857: --
3858: cursor csr_pay_legislation_rules is
3859: select null
3860: from pay_legislation_rules
3861: where legislation_code = l_legislation_code
3862: and rule_type = 'TAX_UNIT'
3863: and rule_mode = 'Y';
3864: --

Line 3955: open csr_pay_legislation_rules;

3951: fetch csr_bg into l_legislation_code;
3952: close csr_bg;
3953: --
3954: hr_utility.set_location(l_proc, 55);
3955: open csr_pay_legislation_rules;
3956: fetch csr_pay_legislation_rules into l_exists;
3957: if csr_pay_legislation_rules%found then
3958: close csr_pay_legislation_rules;
3959: if l_legislation_code = 'US' then

Line 3956: fetch csr_pay_legislation_rules into l_exists;

3952: close csr_bg;
3953: --
3954: hr_utility.set_location(l_proc, 55);
3955: open csr_pay_legislation_rules;
3956: fetch csr_pay_legislation_rules into l_exists;
3957: if csr_pay_legislation_rules%found then
3958: close csr_pay_legislation_rules;
3959: if l_legislation_code = 'US' then
3960: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');

Line 3957: if csr_pay_legislation_rules%found then

3953: --
3954: hr_utility.set_location(l_proc, 55);
3955: open csr_pay_legislation_rules;
3956: fetch csr_pay_legislation_rules into l_exists;
3957: if csr_pay_legislation_rules%found then
3958: close csr_pay_legislation_rules;
3959: if l_legislation_code = 'US' then
3960: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');
3961: else

Line 3958: close csr_pay_legislation_rules;

3954: hr_utility.set_location(l_proc, 55);
3955: open csr_pay_legislation_rules;
3956: fetch csr_pay_legislation_rules into l_exists;
3957: if csr_pay_legislation_rules%found then
3958: close csr_pay_legislation_rules;
3959: if l_legislation_code = 'US' then
3960: hr_utility.set_message(801, 'HR_50001_EMP_ASS_NO_GRE');
3961: else
3962: open csr_tax_unit_message('HR_INV_LEG_ENT_'||l_legislation_code);

Line 3976: close csr_pay_legislation_rules;

3972: hr_multi_message.add
3973: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3974: );
3975: else
3976: close csr_pay_legislation_rules;
3977: end if;
3978: hr_utility.set_location(l_proc, 65);
3979: end if;
3980: end if;