APPS.PER_INC_BUS dependencies on PER_PEOPLE_F

Line 29: ,per_people_f per

25: --
26: cursor csr_sec_grp is
27: select null
28: from per_work_incidents inc
29: ,per_people_f per
30: ,hr_organization_information hoi
31: where inc.incident_id = p_incident_id
32: and per.person_id = inc.person_id
33: and hoi.organization_id = per.business_group_id

Line 92: per_people_f per,

88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_work_incidents inc,
92: per_people_f per,
93: per_business_groups pbg
94: where inc.incident_id = p_incident_id
95: and inc.person_id = per.person_id
96: and per.business_group_id = pbg.business_group_id;

Line 620: from per_people_f per

616: l_dummy number;
617: --
618: cursor csr_person_id is
619: select null
620: from per_people_f per
621: where per.person_id = p_person_id
622: and p_effective_date between per.effective_start_date
623: and per.effective_end_date;
624: --

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

642: if (p_incident_id is null) then
643: --
644: hr_utility.set_location(l_proc, 10);
645: --
646: -- Check that the person_id is in the per_people_f view on the effective_date.
647: --
648: open csr_person_id;
649: fetch csr_person_id into l_dummy;
650: if csr_person_id%notfound then