DBA Data[Home] [Help]

APPS.PER_ROL_BUS dependencies on PER_ALL_PEOPLE_F

Line 160: -- it exists in per_all_people_f on the effective_date.

156: --
157: -- Desciption :
158: --
159: -- Validate that on insert PERSON_ID is not null and that
160: -- it exists in per_all_people_f on the effective_date.
161: --
162: --
163: -- Pre-conditions : None
164: --

Line 172: -- per_all_people_f on the effective_date.

168: -- p_effective_date
169: --
170: -- Post Success :
171: -- Processing continues if person_id is not null and exists in
172: -- per_all_people_f on the effective_date.
173: --
174: -- Post Failure :
175: -- An application error will be raised and processing is
176: -- terminated.

Line 360: from per_all_people_f p

356: --
357: cursor csr_bg is
358: select p.business_group_id
359: ,j.business_group_id
360: from per_all_people_f p
361: ,per_job_groups j
362: where p.person_id = p_person_id
363: and j.job_group_id = p_job_group_id;
364: --