APPS.PAY_CORE_UTILS dependencies on PER_BUSINESS_GROUPS

Line 35: g_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

31: --
32: g_message_stack message_stack_type;
33: g_message_tokens message_token;
34: --
35: g_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
36: g_leg_code pay_legislation_contexts.legislation_code%type := null;
37: --
38: g_process_path varchar2(2000);
39: g_asg_action_id pay_assignment_actions.assignment_action_id%type;

Line 44: (legislation_code per_business_groups.legislation_code%type

40: --
41: -- Legislative context IV names cache. used in get_leg_context_iv_name.
42: --
43: type t_leg_context_iv_rec is record
44: (legislation_code per_business_groups.legislation_code%type
45: ,non_oracle_local varchar2(30)
46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type

Line 389: from per_business_groups_perf

385: (g_business_group_id is not null and
386: g_business_group_id <> p_bg_id)) then
387: select legislation_code
388: into g_legislation_code
389: from per_business_groups_perf
390: where business_group_id = p_bg_id;
391: --
392: g_business_group_id := p_bg_id;
393: end if;

Line 434: l_leg_code per_business_groups_perf.legislation_code%type;

430: p_asg_act_id in number,
431: p_time_def_id out nocopy number)
432: is
433: --
434: l_leg_code per_business_groups_perf.legislation_code%type;
435: l_bus_grp_id per_business_groups_perf.business_group_id%type;
436: l_asg_id per_all_assignments_f.assignment_id%type;
437: statem varchar2(2000); -- used with dynamic pl/sql
438: sql_cursor integer;

Line 435: l_bus_grp_id per_business_groups_perf.business_group_id%type;

431: p_time_def_id out nocopy number)
432: is
433: --
434: l_leg_code per_business_groups_perf.legislation_code%type;
435: l_bus_grp_id per_business_groups_perf.business_group_id%type;
436: l_asg_id per_all_assignments_f.assignment_id%type;
437: statem varchar2(2000); -- used with dynamic pl/sql
438: sql_cursor integer;
439: l_rows integer;

Line 451: per_business_groups_perf pbg

447: l_bus_grp_id,
448: l_leg_code
449: from pay_assignment_actions paa,
450: pay_payroll_actions ppa,
451: per_business_groups_perf pbg
452: where paa.assignment_action_id = p_asg_act_id
453: and ppa.business_group_id = pbg.business_group_id
454: and paa.payroll_action_id = ppa.payroll_action_id;
455: --

Line 1601: per_business_groups_perf pbg

1597: cursor get_contexts (p_bus_grp in number) is
1598: select fc.context_name,
1599: pbg.legislation_code
1600: from ff_contexts fc,
1601: per_business_groups_perf pbg
1602: where pbg.business_group_id = p_bus_grp
1603: and fc.context_name in ('JURISDICTION_CODE',
1604: 'SOURCE_ID',
1605: 'SOURCE_TEXT',

Line 2003: l_bg_leg_code per_business_groups.legislation_code%type;

1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;
2005: l_upgrade_status pay_upgrade_status.status%type;
2006: l_check_upgrade boolean;
2007: l_dummy number;

Line 2032: from per_business_groups_perf pbg

2028: if p_bus_grp_id is not null then
2029: --
2030: select pbg.legislation_code
2031: into l_bg_leg_code
2032: from per_business_groups_perf pbg
2033: where pbg.business_group_id = p_bus_grp_id;
2034: --
2035: end if;
2036: --

Line 2290: per_business_groups_perf pbg

2286: select pbg.legislation_code
2287: into g_leg_code
2288: from pay_assignment_actions paa,
2289: pay_payroll_actions ppa,
2290: per_business_groups_perf pbg
2291: where paa.assignment_action_id = p_asg_act_id
2292: and ppa.business_group_id = pbg.business_group_id
2293: and paa.payroll_action_id = ppa.payroll_action_id;
2294: end if;