DBA Data[Home] [Help]

APPS.EDW_HR_ASG_CHNG_M_SIZING dependencies on HR_LOOKUPS

Line 20: FROM hr_lookups

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

Line 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

Line 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

Line 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

Line 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

Line 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

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