[Home] [Help]
133: and (element.legislation_code = 'US'
134: or (element.legislation_code is null
135: and exists (
136: select 1
137: from per_business_groups_perf BIZ_GRP
138: where element.business_group_id = biz_grp.business_group_id
139: and biz_grp.legislation_code = 'US')))
140: /* and there is or is not an input value indicating that the entry must be
141: processed separately, depending upon the parameter */
235: and (element.legislation_code = 'US'
236: or (element.legislation_code is null
237: and exists (
238: select 1
239: from per_business_groups_perf BIZ_GRP
240: where element.business_group_id = biz_grp.business_group_id
241: and biz_grp.legislation_code = 'US')))
242: /* and there is or is not an input value indicating that the entry must be
243: processed separately, depending upon the parameter */
1802: ) return varchar2 is
1803: --
1804: cursor cur_leg is
1805: select legislation_code
1806: from per_business_groups_perf
1807: where business_group_id = p_business_group_id;
1808: --
1809: v_legislation_code per_business_groups.legislation_code%TYPE;
1810: v_proc varchar2(72) := g_package||'get_legislation_code';
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3871: , pay_consolidation_sets con
3872: , per_business_groups_perf bus
3873: where /* Assignment's Payroll details */
3874: asg.assignment_id = p_assignment_id
3875: and v_cur_date between asg.effective_start_date
3876: and asg.effective_end_date
4363: hr_utility.set_location(v_proc, 6);
4364: --
4365: select pbg.legislation_code
4366: into v_leg_code
4367: from per_business_groups_perf pbg,
4368: pay_payroll_actions ppa
4369: where ppa.payroll_action_id = p_payroll_action_id
4370: and pbg.business_group_id = ppa.business_group_id;
4371: --