APPS.PAY_CORE_UTILS dependencies on PER_BUSINESS_GROUPS_PERF

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