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 865: from per_business_groups_perf pbg

861: and nvl(end_date_active,hr_api.g_eot);
862: --
863: cursor csr_valid_id_flex_num is
864: select null
865: from per_business_groups_perf pbg
866: ,pay_people_groups ppg
867: where ppg.people_group_id = p_people_group_id
868: and pbg.people_group_structure = to_char(ppg.id_flex_num)
869: and pbg.business_group_id = p_business_group_id;

Line 955: -- people_group_structure on per_business_groups for

951: hr_utility.set_location(l_proc, 60);
952: --
953: -- Check that the id_flex_num value for the
954: -- people_group_id can be cross referenced to the
955: -- people_group_structure on per_business_groups for
956: -- the assignment business group
957: --
958: open csr_valid_id_flex_num;
959: fetch csr_valid_id_flex_num into l_exists;

Line 3841: l_legislation_code per_business_groups.legislation_code%TYPE;

3837: --
3838: l_exists varchar2(1);
3839: l_api_updating boolean;
3840: l_proc varchar2(72) := g_package||'chk_soft_coding_keyflex_id';
3841: l_legislation_code per_business_groups.legislation_code%TYPE;
3842: --
3843: --
3844: cursor csr_valid_keyflex is
3845: select null

Line 3855: from per_business_groups_perf

3851: and nvl(end_date_active,hr_api.g_eot);
3852: --
3853: cursor csr_bg is
3854: select legislation_code
3855: from per_business_groups_perf
3856: where business_group_id = p_business_group_id;
3857: --
3858: cursor csr_pay_legislation_rules is
3859: select null