APPS.HR_UTIL_MISC_WEB dependencies on PER_BUSINESS_GROUPS

Line 243: from per_business_groups pbg

239: -- with a change to the table per_all_people_f instead of per_people_f.
240: -----------------------------------------------------------------------------
241: cursor csr_leg_code is
242: select pbg.legislation_code
243: from per_business_groups pbg
244: , per_all_people_f per
245: where per.person_id = p_person_id
246: and pbg.business_group_id = per.business_group_id
247: and p_effective_date between per.effective_start_date

Line 254: l_legislation_code per_business_groups.legislation_code%type default null;

250:
251:
252: -- l_proc_name varchar2(200) default 'get_person_rec';
253: l_person_rec per_people_f%ROWTYPE;
254: l_legislation_code per_business_groups.legislation_code%type default null;
255: l_proc constant varchar2(100) := g_package || ' get_person_rec';
256:
257: BEGIN
258: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2336: RETURN per_business_groups.business_group_id%TYPE IS

2332: ||===========================================================================
2333: */
2334: FUNCTION get_business_group_id
2335: (p_person_id IN NUMBER DEFAULT NULL)
2336: RETURN per_business_groups.business_group_id%TYPE IS
2337:
2338: -- Local Variables.
2339: ln_business_group_id per_business_groups.business_group_id%TYPE;
2340: ln_person_rec per_people_f%ROWTYPE;

Line 2339: ln_business_group_id per_business_groups.business_group_id%TYPE;

2335: (p_person_id IN NUMBER DEFAULT NULL)
2336: RETURN per_business_groups.business_group_id%TYPE IS
2337:
2338: -- Local Variables.
2339: ln_business_group_id per_business_groups.business_group_id%TYPE;
2340: ln_person_rec per_people_f%ROWTYPE;
2341: l_person_id per_people_f.person_id%type;
2342: l_proc constant varchar2(100) := g_package || ' get_business_group_id';
2343: