eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PDT_BUS dependencies on PER_BUSINESS_GROUPS

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 428: -- in per_business_groups

424: -- ---------------------------------------------------------------------------
425: --
426: -- Desciption:
427: -- This procedures validates that both from and to business group ids exist
428: -- in per_business_groups
429: --
430: -- Pre-conditions :
431: -- None
432: --

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 1331: from per_business_groups pbg

1327: l_global_num_set fnd_profile_option_values.profile_option_value%type;
1328: --
1329: cursor csr_numgen_method is
1330: select pbg.method_of_generation_emp_num
1331: from per_business_groups pbg
1332: where pbg.business_group_id=p_to_business_group_id;
1333: --
1334: cursor csr_check_host_number is
1335: select employee_number

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 2937: l_legislation_code per_business_groups.legislation_code%type;

2933: --
2934: l_proc varchar2(72) := g_package||'chk_payroll_id';
2935: l_api_updating boolean;
2936: l_dummy number;
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

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 3064: l_legislation_code per_business_groups.legislation_code%type;

3060: l_proc varchar2(72) := g_package||'chk_assignment_status_type_id';
3061: l_api_updating boolean;
3062: l_active_flag per_assignment_status_types.active_flag%type;
3063: l_per_system_status per_assignment_status_types.per_system_status%type;
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

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 3077: cursor csr_check_asg_status(p_legislation_code per_business_groups.legislation_code%TYPE) is

3073: from per_ass_status_type_amends
3074: where assignment_status_type_id = p_assignment_status_type_id
3075: and business_group_id = p_to_business_group_id;
3076: --
3077: cursor csr_check_asg_status(p_legislation_code per_business_groups.legislation_code%TYPE) is
3078: select active_flag, per_system_status
3079: from per_assignment_status_types
3080: where assignment_status_type_id = p_assignment_status_type_id
3081: and nvl(business_group_id,p_to_business_group_id) = p_to_business_group_id

Line 3450: l_business_group_id per_business_groups.business_group_id%TYPE;

3446: ) is
3447: --
3448: l_proc varchar2(72) := g_package||'chk_pay_basis_id';
3449: l_api_updating boolean;
3450: l_business_group_id per_business_groups.business_group_id%TYPE;
3451: --
3452: cursor csr_check_pay_basis is
3453: select business_group_id
3454: from per_pay_bases

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'