APPS.PAY_CORE_UTILS dependencies on PER_BUSINESS_GROUPS_PERF

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 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;