APPS.HR_PDT_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 30: from per_business_groups_perf pbg

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , hr_person_deployments pdt
32: where pdt.person_deployment_id = p_person_deployment_id
33: and pbg.business_group_id = pdt.to_business_group_id;
34: --

Line 97: from per_business_groups_perf pbg

93: -- Declare cursor
94: --
95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups_perf pbg
98: , hr_person_deployments pdt
99: where pdt.person_deployment_id = p_person_deployment_id
100: and pbg.business_group_id = pdt.to_business_group_id;
101: --

Line 460: from per_business_groups_perf

456: l_dummy number;
457: --
458: cursor csr_bg_exists(p_bg_id in number) is
459: select 1
460: from per_business_groups_perf
461: where business_group_id = p_bg_id;
462: begin
463: hr_utility.set_location('Entering:'||l_proc, 10);
464: --

Line 1951: from per_business_groups_perf

1947: from per_organization_units
1948: where organization_id = p_organization_id
1949: UNION
1950: select 1
1951: from per_business_groups_perf
1952: where business_group_id = p_to_business_group_id;
1953: --
1954: begin
1955: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2941: from per_business_groups_perf

2937: l_legislation_code per_business_groups.legislation_code%type;
2938: --
2939: cursor csr_get_leg_code is
2940: select legislation_code
2941: from per_business_groups_perf
2942: where business_group_id = p_to_business_group_id;
2943: --
2944: cursor csr_check_payroll is
2945: select 1

Line 3068: from per_business_groups_perf

3064: l_legislation_code per_business_groups.legislation_code%type;
3065: --
3066: cursor csr_get_leg_code is
3067: select legislation_code
3068: from per_business_groups_perf
3069: where business_group_id = p_to_business_group_id;
3070: --
3071: cursor csr_check_asg_status_amend is
3072: select active_flag, per_system_status

Line 3540: l_bg_id_flex_num per_business_groups_perf.people_group_structure%type;

3536: l_proc varchar2(72) := g_package||'chk_people_group_id';
3537: l_api_updating boolean;
3538: l_id_flex_num pay_people_groups.id_flex_num%type;
3539: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
3540: l_bg_id_flex_num per_business_groups_perf.people_group_structure%type;
3541: --
3542: cursor csr_check_grp is
3543: select enabled_flag,id_flex_num
3544: from pay_people_groups

Line 3551: from per_business_groups_perf

3547: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
3548: --
3549: cursor csr_get_bg_flex is
3550: select people_group_structure
3551: from per_business_groups_perf
3552: where business_group_id = p_to_business_group_id;
3553: --
3554: begin
3555: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3666: l_legislation_code per_business_groups_perf.legislation_code%type;

3662: --
3663: l_proc varchar2(72) := g_package||'chk_soft_coding_keyflex_id';
3664: l_api_updating boolean;
3665: l_dummy number;
3666: l_legislation_code per_business_groups_perf.legislation_code%type;
3667: --
3668: cursor csr_check_scl is
3669: select 1
3670: from hr_soft_coding_keyflex

Line 3678: from per_business_groups_perf

3674: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
3675: --
3676: cursor csr_bg_leg is
3677: select legislation_code
3678: from per_business_groups_perf
3679: where business_group_id = p_to_business_group_id;
3680: --
3681: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is
3682: select 1

Line 3681: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is

3677: select legislation_code
3678: from per_business_groups_perf
3679: where business_group_id = p_to_business_group_id;
3680: --
3681: cursor csr_pay_legislation_rules(p_legislation_code per_business_groups_perf.legislation_code%type) is
3682: select 1
3683: from pay_legislation_rules
3684: where legislation_code = p_legislation_code
3685: and rule_type = 'TAX_UNIT'