APPS.PAY_ITERATE dependencies on PER_BUSINESS_GROUPS

Line 500: l_leg_code per_business_groups.legislation_code%type;

496: l_statem varchar2(2000); -- used with dynamic pl/sql
497: sql_cursor integer;
498: l_rows integer;
499: --
500: l_leg_code per_business_groups.legislation_code%type;
501: l_flag pay_legislation_rules.rule_mode%type;
502: l_found boolean;
503: l_factor number;
504: --

Line 509: from per_business_groups_perf

505: begin
506: --
507: select legislation_code
508: into l_leg_code
509: from per_business_groups_perf
510: where business_group_id = p_bg_id;
511: --
512: pay_core_utils.get_legislation_rule(p_legrul_name => 'ITERATE_DYN_HI_GRS_FACTOR',
513: p_legislation => l_leg_code,

Line 631: from per_business_groups pbg

627: , object_version_number
628: from pay_run_types_f
629: where run_type_name = p_rt_name
630: and business_group_id = (select pbg.business_group_id
631: from per_business_groups pbg
632: where upper(pbg.name) = upper(p_business_group))
633: and legislation_code is null;
634: --
635: cursor s_row_exists

Line 732: from per_business_groups

728: --
729: cursor get_bg_id
730: is
731: select business_group_id
732: from per_business_groups
733: where upper(name) = upper(p_business_group);
734: --
735: l_mode varchar2(30) := 'USER';
736: l_rt_id number;

Line 1981: from per_business_groups pbg

1977: from pay_run_type_usages_f
1978: where parent_run_type_id = p_parent_rt_id
1979: and child_run_type_id = p_child_rt_id
1980: and business_group_id = (select pbg.business_group_id
1981: from per_business_groups pbg
1982: where upper(pbg.name) = p_business_group)
1983: and legislation_code is null;
1984: --
1985: cursor s_row_exists(p_parent_rt_id number

Line 2024: from per_business_groups

2020: --
2021: cursor get_bg_id(p_bg_name varchar2)
2022: is
2023: select business_group_id
2024: from per_business_groups
2025: where UPPER(name) = upper(p_bg_name);
2026: --
2027: cursor get_parent_id (p_bg_id number)
2028: is

Line 2586: from per_business_groups

2582: --
2583: cursor get_business_group_id
2584: is
2585: select business_group_id
2586: from per_business_groups
2587: where upper(name) = p_rt_bg;
2588: --
2589: cursor get_run_type_id(p_bg_id number)
2590: is

Line 2766: from per_business_groups

2762: select business_group_id
2763: , legislation_code
2764: into l_bg_id
2765: , l_lc
2766: from per_business_groups
2767: where UPPER(name) = p_business_group;
2768: --
2769: hr_utility.set_location('pay_iterate.up_run_type_org_method',20);
2770: --

Line 2917: from per_business_groups

2913: from pay_element_type_usages_f
2914: where run_type_id = l_in_rt_id
2915: and element_type_id = l_in_et_id
2916: and ((business_group_id in (select business_group_id
2917: from per_business_groups
2918: where legislation_code = p_legislative_code))
2919: or (legislation_code = p_legislative_code)
2920: or (business_group_id is null
2921: and legislation_code is null));

Line 3087: from per_business_groups

3083: select business_group_id
3084: , legislation_code
3085: into l_in_bg_id
3086: , l_in_lc
3087: from per_business_groups
3088: where UPPER(name) = p_business_group;
3089: --
3090: end if;
3091: --

Line 3240: from per_business_groups pbg

3236: --
3237: cursor get_bg_id (p_bg_name varchar2)
3238: is
3239: select pbg.business_group_id
3240: from per_business_groups pbg
3241: where pbg.name = p_bg_name;
3242: --
3243: cursor csr_child_cumulative(p_leg_code varchar2
3244: ,p_bg number

Line 3257: l_bg per_business_groups.business_group_id%type;

3253: and nvl(prt.business_group_id, -1) = nvl(p_bg, -1)
3254: and prt.run_type_name = p_rt_name
3255: and prt.run_type_id = rtu.child_run_type_id;
3256: --
3257: l_bg per_business_groups.business_group_id%type;
3258: l_rt_name pay_run_types_f.run_type_name%type;
3259: l_rt_method pay_run_types_f.run_method%type;
3260: l_meth_order varchar2(2);
3261: --