APPS.PER_KW_XDO_REPORT dependencies on HR_LOOKUPS

Line 76: ,hr_lookups hr1

72: ,per_disabilities_f disb
73: ,per_jobs job
74: ,per_all_positions pos
75: ,per_periods_of_service period
76: ,hr_lookups hr1
77: ,hr_lookups hr2
78: ,hr_lookups hr3
79: ,hr_all_organization_units org
80: --,hr_all_organization_units emp

Line 77: ,hr_lookups hr2

73: ,per_jobs job
74: ,per_all_positions pos
75: ,per_periods_of_service period
76: ,hr_lookups hr1
77: ,hr_lookups hr2
78: ,hr_lookups hr3
79: ,hr_all_organization_units org
80: --,hr_all_organization_units emp
81: ,hr_soft_coding_keyflex hsck

Line 78: ,hr_lookups hr3

74: ,per_all_positions pos
75: ,per_periods_of_service period
76: ,hr_lookups hr1
77: ,hr_lookups hr2
78: ,hr_lookups hr3
79: ,hr_all_organization_units org
80: --,hr_all_organization_units emp
81: ,hr_soft_coding_keyflex hsck
82: WHERE assg.person_id = people.person_id

Line 207: FROM hr_lookups

203: IF p_disability_type IS NOT NULL THEN
204: BEGIN
205: SELECT meaning
206: INTO l_disability_type
207: FROM hr_lookups
208: WHERE lookup_type = 'DISABILITY_CATEGORY'
209: AND lookup_code = p_disability_type;
210: EXCEPTION
211: WHEN OTHERS THEN

Line 219: FROM hr_lookups

215: IF p_disability_status IS NOT NULL THEN
216: BEGIN
217: SELECT meaning
218: INTO l_disability_status
219: FROM hr_lookups
220: WHERE lookup_type = 'DISABILITY_STATUS'
221: AND lookup_code = p_disability_status;
222: EXCEPTION
223: WHEN OTHERS THEN

Line 703: FROM hr_lookups

699: IF p_units IS NOT NULL THEN
700: BEGIN
701: SELECT meaning
702: INTO l_units
703: FROM hr_lookups
704: WHERE lookup_type = 'QUALIFYING_UNITS'
705: AND lookup_code = p_units;
706: EXCEPTION
707: WHEN OTHERS THEN

Line 1094: from hr_lookups

1090: ,p_lookup_code varchar2)
1091: RETURN VARCHAR2 IS
1092: CURSOR csr_lookup IS
1093: select meaning
1094: from hr_lookups
1095: where lookup_type = p_lookup_type
1096: and lookup_code = p_lookup_code;
1097: l_meaning hr_lookups.meaning%type;
1098: BEGIN

Line 1097: l_meaning hr_lookups.meaning%type;

1093: select meaning
1094: from hr_lookups
1095: where lookup_type = p_lookup_type
1096: and lookup_code = p_lookup_code;
1097: l_meaning hr_lookups.meaning%type;
1098: BEGIN
1099: OPEN csr_lookup;
1100: FETCH csr_lookup INTO l_Meaning;
1101: CLOSE csr_lookup;