DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on PAY_LEGISLATION_RULES

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

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

Line 3683: from pay_legislation_rules

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

Line 3746: open csr_pay_legislation_rules(l_legislation_code);

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

Line 3747: fetch csr_pay_legislation_rules into l_dummy;

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

Line 3748: if csr_pay_legislation_rules%found then

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

Line 3749: close csr_pay_legislation_rules;

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

Line 3767: end if; --csr_pay_legislation_rules found

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