[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
distinct(wi.incident_id) INCIDENT_ID,
wi.incident_date INCIDENT_DATE_ORD,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_BIRTH'),40,' ') DOB, fnd_date.date_to_chardate(wi.DATE_OF_BIRTH) date_of_birth,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB_START_DT'),40,' ') JST, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.JOB_START_DATE)) job_start_date,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DUR_PAY_ENT'),40,' ') DUR, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DUR_OF_PAYMENT_ENT)) dur_of_payment_ent,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_START'),40,' ') DTS, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_STOPPING_WORK)) date_of_stopping_work,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_STOP'),40,' ') DTE, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_RESUMING_WORK)) date_of_resuming_work,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TECH_SAFE'),40,' ') TES, wi.TECHNICAL_SAFETY_ADV,
rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERS_SAFE'),40,' ') PES, wi.PERSONAL_SAFETY_ADV
FROM hr_de_work_incidents_report wi
,per_people_f per
WHERE wi.person_id = per.person_id AND
per.business_group_id = p_business_group_id AND
wi.incident_date BETWEEN per.effective_start_date
AND per.effective_end_date AND
wi.incident_date BETWEEN fnd_date.canonical_to_date(p_from_date)
AND fnd_date.canonical_to_date(p_to_date)
ORDER BY incident_date_ord, wi.person_id;
INSERT INTO fnd_sessions
(session_id
,effective_date)
VALUES
(userenv('sessionid')
,sysdate);