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 297: from per_business_groups_perf

293: (g_business_group_id is not null and
294: g_business_group_id <> p_bg_id)) then
295: select legislation_code
296: into g_legislation_code
297: from per_business_groups_perf
298: where business_group_id = p_bg_id;
299: --
300: g_business_group_id := p_bg_id;
301: end if;

Line 342: l_leg_code per_business_groups_perf.legislation_code%type;

338: p_asg_act_id in number,
339: p_time_def_id out nocopy number)
340: is
341: --
342: l_leg_code per_business_groups_perf.legislation_code%type;
343: l_bus_grp_id per_business_groups_perf.business_group_id%type;
344: l_asg_id per_all_assignments_f.assignment_id%type;
345: statem varchar2(2000); -- used with dynamic pl/sql
346: sql_cursor integer;

Line 343: l_bus_grp_id per_business_groups_perf.business_group_id%type;

339: p_time_def_id out nocopy number)
340: is
341: --
342: l_leg_code per_business_groups_perf.legislation_code%type;
343: l_bus_grp_id per_business_groups_perf.business_group_id%type;
344: l_asg_id per_all_assignments_f.assignment_id%type;
345: statem varchar2(2000); -- used with dynamic pl/sql
346: sql_cursor integer;
347: l_rows integer;

Line 359: per_business_groups_perf pbg

355: l_bus_grp_id,
356: l_leg_code
357: from pay_assignment_actions paa,
358: pay_payroll_actions ppa,
359: per_business_groups_perf pbg
360: where paa.assignment_action_id = p_asg_act_id
361: and ppa.business_group_id = pbg.business_group_id
362: and paa.payroll_action_id = ppa.payroll_action_id;
363: --

Line 1488: per_business_groups_perf pbg

1484: cursor get_contexts (p_bus_grp in number) is
1485: select fc.context_name,
1486: pbg.legislation_code
1487: from ff_contexts fc,
1488: per_business_groups_perf pbg
1489: where pbg.business_group_id = p_bus_grp
1490: and fc.context_name in ('JURISDICTION_CODE',
1491: 'SOURCE_ID',
1492: 'SOURCE_TEXT',

Line 1890: l_bg_leg_code per_business_groups.legislation_code%type;

1886: l_legislation_code pay_upgrade_definitions.legislation_code%type;
1887: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
1888: l_failure_point pay_upgrade_definitions.failure_point%type;
1889: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
1890: l_bg_leg_code per_business_groups.legislation_code%type;
1891: l_status pay_upgrade_status.status%type;
1892: l_upgrade_status pay_upgrade_status.status%type;
1893: l_check_upgrade boolean;
1894: l_dummy number;

Line 1919: from per_business_groups_perf pbg

1915: if p_bus_grp_id is not null then
1916: --
1917: select pbg.legislation_code
1918: into l_bg_leg_code
1919: from per_business_groups_perf pbg
1920: where pbg.business_group_id = p_bus_grp_id;
1921: --
1922: end if;
1923: --

Line 2169: per_business_groups_perf pbg

2165: select pbg.legislation_code
2166: into g_leg_code
2167: from pay_assignment_actions paa,
2168: pay_payroll_actions ppa,
2169: per_business_groups_perf pbg
2170: where paa.assignment_action_id = p_asg_act_id
2171: and ppa.business_group_id = pbg.business_group_id
2172: and paa.payroll_action_id = ppa.payroll_action_id;
2173: end if;