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 23: from per_business_groups_perf pbg

19: begin
20: --
21: select pbg.legislation_code
22: into l_leg_code
23: from per_business_groups_perf pbg
24: where pbg.business_group_id = p_bgp_id;
25: --
26: pay_core_utils.get_legislation_rule
27: (p_legrul_name => 'I',

Line 322: from per_business_groups_perf pbg,

318: begin
319: --
320: select distinct legislation_code
321: into l_leg_code
322: from per_business_groups_perf pbg,
323: per_all_assignments_f paf
324: where paf.assignment_id = p_assignment_id
325: and p_effective_start_date between paf.effective_start_date
326: and paf.effective_end_date