APPS.PER_DIS_BUS dependencies on PER_WORK_INCIDENTS

Line 239: -- Validate that INCIDENT_ID exists in per_work_incidents on the

235: -- ---------------------------------------------------------------------------
236: --
237: -- Desciption :
238: --
239: -- Validate that INCIDENT_ID exists in per_work_incidents on the
240: -- effective_date for the person_id. Check that the value matches
241: -- that of the work incident that is parent of the medical assessment record
242: -- that has previously been linked to the disability, if one exists.
243: --

Line 276: from per_work_incidents pwi

272: is
273: --
274: cursor csr_inc is
275: select null
276: from per_work_incidents pwi
277: where pwi.person_id = p_person_id
278: and pwi.incident_id = p_incident_id
279: and p_effective_date >= pwi.incident_date;
280: --

Line 321: -- Check the incident exists in per_work_incidents

317: hr_utility.set_location(l_proc, 3);
318:
319: if p_incident_id is not null then
320: --
321: -- Check the incident exists in per_work_incidents
322: -- for the person_id, with incident_date <= effective_date
323: --
324: open csr_inc;
325: fetch csr_inc into l_dummy;