[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 */
1783: ) return varchar2 is
1784: --
1785: cursor cur_leg is
1786: select legislation_code
1787: from per_business_groups_perf
1788: where business_group_id = p_business_group_id;
1789: --
1790: v_legislation_code per_business_groups.legislation_code%TYPE;
1791: v_proc varchar2(72) := g_package||'get_legislation_code';
3846: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3847: from per_assignments_f asg
3848: , pay_payrolls_f pro
3849: , pay_consolidation_sets con
3850: , per_business_groups_perf bus
3851: where /* Assignment's Payroll details */
3852: asg.assignment_id = p_assignment_id
3853: and v_cur_date between asg.effective_start_date
3854: and asg.effective_end_date
4341: hr_utility.set_location(v_proc, 6);
4342: --
4343: select pbg.legislation_code
4344: into v_leg_code
4345: from per_business_groups_perf pbg,
4346: pay_payroll_actions ppa
4347: where ppa.payroll_action_id = p_payroll_action_id
4348: and pbg.business_group_id = ppa.business_group_id;
4349: --