DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on PAY_LEGISLATION_RULES

Line 3680: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is

3676: select legislation_code
3677: from per_business_groups_perf
3678: where business_group_id = p_to_business_group_id;
3679: --
3680: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is
3681: select 1
3682: from pay_legislation_rules
3683: where legislation_code = p_legislation_code
3684: and rule_type = 'TAX_UNIT'

Line 3682: from pay_legislation_rules

3678: where business_group_id = p_to_business_group_id;
3679: --
3680: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is
3681: select 1
3682: from pay_legislation_rules
3683: where legislation_code = p_legislation_code
3684: and rule_type = 'TAX_UNIT'
3685: and rule_mode = 'Y';
3686: --

Line 3745: open csr_pay_legislation_rules(l_legislation_code);

3741: open csr_bg_leg;
3742: fetch csr_bg_leg into l_legislation_code;
3743: close csr_bg_leg;
3744: --
3745: open csr_pay_legislation_rules(l_legislation_code);
3746: fetch csr_pay_legislation_rules into l_dummy;
3747: if csr_pay_legislation_rules%found then
3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then

Line 3746: fetch csr_pay_legislation_rules into l_dummy;

3742: fetch csr_bg_leg into l_legislation_code;
3743: close csr_bg_leg;
3744: --
3745: open csr_pay_legislation_rules(l_legislation_code);
3746: fetch csr_pay_legislation_rules into l_dummy;
3747: if csr_pay_legislation_rules%found then
3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then
3750: fnd_message.set_name('PER','HR_50001_EMP_ASS_NO_GRE');

Line 3747: if csr_pay_legislation_rules%found then

3743: close csr_bg_leg;
3744: --
3745: open csr_pay_legislation_rules(l_legislation_code);
3746: fetch csr_pay_legislation_rules into l_dummy;
3747: if csr_pay_legislation_rules%found then
3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then
3750: fnd_message.set_name('PER','HR_50001_EMP_ASS_NO_GRE');
3751: hr_multi_message.add

Line 3748: close csr_pay_legislation_rules;

3744: --
3745: open csr_pay_legislation_rules(l_legislation_code);
3746: fetch csr_pay_legislation_rules into l_dummy;
3747: if csr_pay_legislation_rules%found then
3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then
3750: fnd_message.set_name('PER','HR_50001_EMP_ASS_NO_GRE');
3751: hr_multi_message.add
3752: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');

Line 3766: end if; --csr_pay_legislation_rules found

3762: end if;
3763: hr_multi_message.add
3764: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');
3765: end if; --legislation code
3766: end if; --csr_pay_legislation_rules found
3767: end if; --payroll_id not null
3768: -- end if; --csr_check_scl not found
3769: end if; --soft coding keyflex not null
3770: end if; --api updating