DBA Data[Home] [Help]

APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PER_BUSINESS_GROUPS

Line 15: l_leg_code per_business_groups.legislation_code%type;

11: function is_pog_enable(p_bgp_id in number)
12: return boolean
13: is
14: --
15: l_leg_code per_business_groups.legislation_code%type;
16: l_value pay_legislation_rules.rule_mode%type;
17: l_found boolean;
18: --
19: begin

Line 26: from per_business_groups_perf pbg

22: hr_utility.trace('In is_pog_enable()');
23: end if;
24: select pbg.legislation_code
25: into l_leg_code
26: from per_business_groups_perf pbg
27: where pbg.business_group_id = p_bgp_id;
28: --
29: pay_core_utils.get_legislation_rule
30: (p_legrul_name => 'I',

Line 381: from per_business_groups_perf pbg,

377: hr_utility.trace('In evaluate_asg_group()');
378: end if;
379: select distinct legislation_code, paf.business_group_id
380: into l_leg_code, l_bg_id
381: from per_business_groups_perf pbg,
382: per_all_assignments_f paf
383: where paf.assignment_id = p_assignment_id
384: and p_effective_start_date between paf.effective_start_date
385: and paf.effective_end_date