16: (SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
17: ,lookup_code
18: ,last_update_date
19: ,creation_date
20: FROM hr_lookups
21: WHERE lookup_type = 'YES_NO') t1
22: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
23: ,lookup_code
24: FROM hr_lookups
20: FROM hr_lookups
21: WHERE lookup_type = 'YES_NO') t1
22: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
23: ,lookup_code
24: FROM hr_lookups
25: WHERE lookup_type = 'YES_NO') t2
26: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
27: ,lookup_code
28: FROM hr_lookups
24: FROM hr_lookups
25: WHERE lookup_type = 'YES_NO') t2
26: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
27: ,lookup_code
28: FROM hr_lookups
29: WHERE lookup_type = 'YES_NO') t3
30: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
31: ,lookup_code
32: FROM hr_lookups
28: FROM hr_lookups
29: WHERE lookup_type = 'YES_NO') t3
30: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
31: ,lookup_code
32: FROM hr_lookups
33: WHERE lookup_type = 'YES_NO') t4
34: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
35: ,lookup_code
36: FROM hr_lookups
32: FROM hr_lookups
33: WHERE lookup_type = 'YES_NO') t4
34: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
35: ,lookup_code
36: FROM hr_lookups
37: WHERE lookup_type = 'YES_NO') t5
38: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
39: ,lookup_code
40: FROM hr_lookups
36: FROM hr_lookups
37: WHERE lookup_type = 'YES_NO') t5
38: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
39: ,lookup_code
40: FROM hr_lookups
41: WHERE lookup_type = 'YES_NO') t6
42: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
43: ,lookup_code
44: FROM hr_lookups
40: FROM hr_lookups
41: WHERE lookup_type = 'YES_NO') t6
42: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
43: ,lookup_code
44: FROM hr_lookups
45: WHERE lookup_type = 'YES_NO') t7;
46:
47: BEGIN
48: