eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DE_WORK_INCIDENT_REPORT dependencies on HR_GENERAL

Line 24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,

20: ,p_to_date VARCHAR2) IS
21: SELECT
22: distinct(wi.incident_id) INCIDENT_ID,
23: wi.incident_date INCIDENT_DATE_ORD,
24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,

Line 25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,

21: SELECT
22: distinct(wi.incident_id) INCIDENT_ID,
23: wi.incident_date INCIDENT_DATE_ORD,
24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,

Line 26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,

22: distinct(wi.incident_id) INCIDENT_ID,
23: wi.incident_date INCIDENT_DATE_ORD,
24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,

Line 27: 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,

23: wi.incident_date INCIDENT_DATE_ORD,
24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,

Line 28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,

24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,

Line 29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,

25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,

Line 30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,

26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,

Line 31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,

27: 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,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,

Line 32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,

28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,

Line 33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,

29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,

Line 34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,

30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,

Line 35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,

31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,

Line 36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,

32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,
33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,

Line 37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,

33: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','NATIONALITY'),40,' ') NAT, hr_general.decode_lookup('NATIONALITY', wi.NATIONALITY) nationality,
34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,

Line 38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,

34: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ASSGT_ORG_NAME'),40,' ') ORG, wi.ASSGT_ORG_NAME ,
35: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BETRIEBS'),40,' ') BET, wi.BETRIEBSNUMBER ,
36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,

Line 40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,

36: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUP_OFF_NAME'),40,' ') SUP, rtrim(substr(wi.SUP_OFF_NAME,1,240)) SUP_OFF,
37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,

Line 41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,

37: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LIAB_PROV_NAME'),40,' ') LIP, rtrim(substr(wi.LIAB_PROV_NAME, 1, 240)) LIAB_PROV,
38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,

Line 42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,

38: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MEM_NO'),40,' ') MEM, substr(wi.MEMBERSHIP_NO,1,20) MEM_NO,
39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,

Line 43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,

39: substr(wi.loc_id_of_liab_prov,1,20) LOC_ID,
40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,

Line 44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,

40: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD1'),40,' ') AD1, rtrim(substr(wi.ADDRESS_LINE_1, 1, 240)) ADD1,
41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,

Line 45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,

41: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD2'),40,' ') AD2, rtrim(substr(wi.ADDRESS_LINE_2, 1, 240)) ADD2,
42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,

Line 46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,

42: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD3'),40,' ') AD3, rtrim(substr(wi.ADDRESS_LINE_3, 1, 240)) ADD3,
43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,

Line 47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,

43: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TOWN'),40,' ') TOW, rtrim(substr(wi.TOWN_OR_CITY, 1, 150)) TOWN,
44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,

Line 48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,

44: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COUNTRY'),40,' ') CTY, rtrim(substr(wi.COUNTRY, 1, 100)) CTRY,
45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,

Line 49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,

45: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','POSTAL'),40,' ') POC, substr(wi.POSTAL_CODE, 1, 20) POST,
46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,

Line 50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,

46: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','BODY_PART'),40,' ') BOD, wi.BODY_PART,
47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,

Line 51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,

47: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INJURY_TYPE'),40,' ') INJ, hr_general.decode_lookup('INJURY_TYPE', wi.INJURY_TYPE) injury_type,
48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,

Line 52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,

48: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DOC_NAME'),40, ' ') DOC, wi.DOCTOR_NAME,
49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,

Line 53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,

49: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TYPE'),40,' ') INT, wi.D_INCIDENT_TYPE,
50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,

Line 54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,

50: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','HOSP_DETAILS'),40,' ') HOS, wi.HOSPITAL_DETAILS,
51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,

Line 55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,

51: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_TIME'),40,' ') INM, wi.INCIDENT_TIME,
52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,

Line 56: 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,

52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,

Line 57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,

53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,

Line 58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,

54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,

Line 59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,

55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,

Line 60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,

56: 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,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,

Line 61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,

57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,

Line 62: 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,

58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,

Line 63: 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,

59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,

Line 64: 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,

60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,

Line 65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,

61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,

Line 66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,

62: 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,
63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,

Line 67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,

63: 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,
64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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,

Line 68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,

64: 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,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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,

Line 69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,

65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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

Line 70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,

66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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

Line 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,

67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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

Line 72: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TECH_SAFE'),40,' ') TES, wi.TECHNICAL_SAFETY_ADV,

68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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

Line 73: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERS_SAFE'),40,' ') PES, wi.PERSONAL_SAFETY_ADV

69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
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

Line 104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','WI_REP_TITLE'), 40, ' '));

100: -- Print titles on 1st page
101: --
102: fnd_file.new_line(fnd_file.output, 12);
103: fnd_file.put_line(fnd_file.output, '**********************************************************');
104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','WI_REP_TITLE'), 40, ' '));
105: fnd_file.put_line(fnd_file.output, '**********************************************************');
106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '
107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));
108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '

Line 106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '

102: fnd_file.new_line(fnd_file.output, 12);
103: fnd_file.put_line(fnd_file.output, '**********************************************************');
104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','WI_REP_TITLE'), 40, ' '));
105: fnd_file.put_line(fnd_file.output, '**********************************************************');
106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '
107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));
108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '
109: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_to_date)));
110: fnd_file.new_line(fnd_file.output, 45);

Line 108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '

104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','WI_REP_TITLE'), 40, ' '));
105: fnd_file.put_line(fnd_file.output, '**********************************************************');
106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '
107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));
108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '
109: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_to_date)));
110: fnd_file.new_line(fnd_file.output, 45);
111: --
112: --