DBA Data[Home] [Help]

APPS.PER_CTR_BUS dependencies on PER_ALL_PEOPLE_F

Line 84: from per_all_people_f ppf -- bug 3577703. Use table instead of secure view.

80: l_proc varchar2(72) := g_package||'chk_person_id';
81: --
82: cursor csr_get_bus_grp is
83: select ppf.business_group_id
84: from per_all_people_f ppf -- bug 3577703. Use table instead of secure view.
85: where ppf.person_id = p_person_id
86: and p_effective_date between
87: ppf.effective_start_date and ppf.effective_end_date;
88: --

Line 167: from per_all_people_f ppf -- Bug 3577703. Use table per_all_people_f.

163: l_proc varchar2(72) := g_package||'chk_person_id';
164: --
165: cursor csr_get_bus_grp is
166: select ppf.business_group_id
167: from per_all_people_f ppf -- Bug 3577703. Use table per_all_people_f.
168: where ppf.person_id = p_contact_person_id
169: and p_effective_date between
170: ppf.effective_start_date and ppf.effective_end_date;
171: --