DBA Data[Home] [Help]

APPS.HR_DE_WORK_INCIDENT_REPORT dependencies on PER_PEOPLE_F

Line 75: ,per_people_f per

71: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_MACH'),40,' ') DTM, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_MACHINE_BUILD)) date_of_machine_build,
72: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TECH_SAFE'),40,' ') TES, wi.TECHNICAL_SAFETY_ADV,
73: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERS_SAFE'),40,' ') PES, wi.PERSONAL_SAFETY_ADV
74: FROM hr_de_work_incidents_report wi
75: ,per_people_f per
76: WHERE wi.person_id = per.person_id AND
77: per.business_group_id = p_business_group_id AND
78: wi.incident_date BETWEEN per.effective_start_date
79: AND per.effective_end_date AND