APPS.PER_MEA_BUS dependencies on PER_PEOPLE_F

Line 244: FROM per_people_f per

240: l_dummy number;
241: --
242: CURSOR csr_person_id IS
243: SELECT null
244: FROM per_people_f per
245: WHERE per.person_id = p_person_id
246: AND p_effective_date BETWEEN per.effective_start_date
247: AND per.effective_end_date;
248: --

Line 271: -- Check that the person_id is in the per_people_f view on the effective_date.

267: if (p_medical_assessment_id is null) then
268: --
269: hr_utility.set_location(l_proc, 10);
270: --
271: -- Check that the person_id is in the per_people_f view on the effective_date.
272: --
273: open csr_person_id;
274: fetch csr_person_id into l_dummy;
275: --

Line 1110: per_people_f per

1106: CURSOR csr_sec_grp is
1107: SELECT pbg.security_group_id
1108: FROM per_business_groups pbg,
1109: per_medical_assessments mea,
1110: per_people_f per
1111: WHERE mea.medical_assessment_id = p_medical_assessment_id
1112: AND per.person_id = mea.person_id
1113: AND pbg.business_group_id = per.business_group_id;
1114: --

Line 1171: per_people_f per,

1167: --
1168: cursor csr_leg_code is
1169: select pbg.legislation_code
1170: from per_medical_assessments mea,
1171: per_people_f per,
1172: per_business_groups pbg
1173: where mea.medical_assessment_id = p_medical_assessment_id
1174: and mea.person_id = per.person_id
1175: and per.business_group_id = pbg.business_group_id;