APPS.PER_ASG_BUS2 dependencies on PER_BUSINESS_GROUPS

Line 27: l_business_group_id per_business_groups.business_group_id%TYPE;

23: is
24: --
25: l_proc varchar2(72) := g_package||'chk_pay_basis_id';
26: l_api_updating boolean;
27: l_business_group_id per_business_groups.business_group_id%TYPE;
28: l_max_pp_chg_date date;
29: --
30: --
31: -- Cursor to validate that pay basis exists in PER_PAY_BASES

Line 254: l_legislation_code per_business_groups.legislation_code%TYPE;

250: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
251: )
252: is
253: --
254: l_legislation_code per_business_groups.legislation_code%TYPE;
255: l_api_updating boolean;
256: l_cur_opu_effective_start_date date;
257: l_cur_opu_effective_end_date date;
258: l_business_group_id number(15);

Line 279: from per_business_groups_perf

275:
276: -- Bug 979903
277: cursor csr_get_legc_code is
278: select legislation_code
279: from per_business_groups_perf
280: where business_group_id = p_business_group_id;
281: --
282: --VS Bug:1402408. 11/14/00
283: cursor csr_payroll_exists is

Line 825: from per_business_groups_perf pbg

821: and nvl(end_date_active,hr_api.g_eot);
822: --
823: cursor csr_valid_id_flex_num is
824: select null
825: from per_business_groups_perf pbg
826: ,pay_people_groups ppg
827: where ppg.people_group_id = p_people_group_id
828: and pbg.people_group_structure = to_char(ppg.id_flex_num)
829: and pbg.business_group_id = p_business_group_id;

Line 915: -- people_group_structure on per_business_groups for

911: hr_utility.set_location(l_proc, 60);
912: --
913: -- Check that the id_flex_num value for the
914: -- people_group_id can be cross referenced to the
915: -- people_group_structure on per_business_groups for
916: -- the assignment business group
917: --
918: open csr_valid_id_flex_num;
919: fetch csr_valid_id_flex_num into l_exists;

Line 3801: l_legislation_code per_business_groups.legislation_code%TYPE;

3797: --
3798: l_exists varchar2(1);
3799: l_api_updating boolean;
3800: l_proc varchar2(72) := g_package||'chk_soft_coding_keyflex_id';
3801: l_legislation_code per_business_groups.legislation_code%TYPE;
3802: --
3803: --
3804: cursor csr_valid_keyflex is
3805: select null

Line 3815: from per_business_groups_perf

3811: and nvl(end_date_active,hr_api.g_eot);
3812: --
3813: cursor csr_bg is
3814: select legislation_code
3815: from per_business_groups_perf
3816: where business_group_id = p_business_group_id;
3817: --
3818: cursor csr_pay_legislation_rules is
3819: select null