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.EDW_HR_ASG_CHNG_M_SIZING dependencies on HR_GENERAL

Line 16: (SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(*) total
15: FROM
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

Line 22: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
25: WHERE lookup_type = 'YES_NO') t2
26: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

Line 26: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
29: WHERE lookup_type = 'YES_NO') t3
30: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

Line 30: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
33: WHERE lookup_type = 'YES_NO') t4
34: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

Line 34: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
37: WHERE lookup_type = 'YES_NO') t5
38: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

Line 38: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
41: WHERE lookup_type = 'YES_NO') t6
42: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

Line 42: ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup

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
45: WHERE lookup_type = 'YES_NO') t7;
46:

Line 88: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0))

84:
85:
86: CURSOR flag_cur IS
87: SELECT
88: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0))
89: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))
90: FROM dual;
91:
92: BEGIN

Line 89: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))

85:
86: CURSOR flag_cur IS
87: SELECT
88: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0))
89: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))
90: FROM dual;
91:
92: BEGIN
93: