DBA Data[Home] [Help]

APPS.PER_PPB_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_pay_bases ppb
31: where ppb.pay_basis_id = p_pay_basis_id
32: and pbg.business_group_id = ppb.business_group_id;
33: --

Line 93: from per_business_groups pbg

89: -- Declare cursor
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_pay_bases ppb
95: where ppb.pay_basis_id = p_pay_basis_id
96: and pbg.business_group_id = ppb.business_group_id;
97: --

Line 1383: from per_business_groups_perf pbg

1379:
1380:
1381: select pbg.legislation_code
1382: into l_leg_code
1383: from per_business_groups_perf pbg
1384: where pbg.business_group_id = p_rec.business_group_id;
1385:
1386: --
1387: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1463: from per_business_groups_perf pbg

1459: --
1460: Begin
1461: select pbg.legislation_code
1462: into l_leg_code
1463: from per_business_groups_perf pbg
1464: , per_pay_bases ppb
1465: where ppb.pay_basis_id = p_rec.pay_basis_id
1466: and pbg.business_group_id = ppb.business_group_id;
1467: --