APPS.PAY_AE_SI_REPORTS dependencies on HR_LOOKUPS

Line 56: from hr_lookups

52: ,p_lookup_code varchar2)
53: RETURN VARCHAR2 IS
54: CURSOR csr_lookup IS
55: select meaning
56: from hr_lookups
57: where lookup_type = p_lookup_type
58: and lookup_code = p_lookup_code;
59: l_meaning hr_lookups.meaning%type;
60: BEGIN

Line 59: l_meaning hr_lookups.meaning%type;

55: select meaning
56: from hr_lookups
57: where lookup_type = p_lookup_type
58: and lookup_code = p_lookup_code;
59: l_meaning hr_lookups.meaning%type;
60: BEGIN
61: OPEN csr_lookup;
62: FETCH csr_lookup INTO l_Meaning;
63: CLOSE csr_lookup;

Line 117: FROM hr_lookups hl

113:
114: /*Cursor for fetching Employer's Emirate */
115: CURSOR csr_employer_emirate (l_emirate varchar2) IS
116: SELECT hl.meaning
117: FROM hr_lookups hl
118: WHERE hl.lookup_code = l_emirate
119: AND hl.lookup_type = 'AE_EMIRATE'
120: AND hl.enabled_flag = 'Y';
121:

Line 175: FROM hr_lookups hl

171:
172: /* Cursor for fetching the person's gender meaning */
173: CURSOR csr_p_gender (l_sex varchar2) IS
174: SELECT hl.meaning
175: FROM hr_lookups hl
176: WHERE hl.lookup_type = 'SEX'
177: AND hl.lookup_code = l_sex
178: AND hl.enabled_flag = 'Y';
179:

Line 183: FROM hr_lookups hl

179:
180: /* Cursor for fetching the person's marital status */
181: CURSOR csr_p_mar_status (l_mar_stat varchar2) IS
182: SELECT hl.meaning
183: FROM hr_lookups hl
184: WHERE hl.lookup_type = 'MAR_STATUS'
185: AND hl.lookup_code = l_mar_stat
186: AND hl.enabled_flag = 'Y';
187:

Line 208: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl

204:
205: /* Cursor for fetching the person's qualification data */
206: CURSOR csr_p_qual_data (l_person_id number,l_qual_id number) IS
207: SELECT pq.title , pq.attendance_id , hl.meaning
208: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl
209: WHERE pq.person_id = l_person_id
210: AND pq.qualification_id = l_qual_id
211: AND pst.qualification_id = pq.qualification_id
212: AND pst.major = 'Y'

Line 273: FROM hr_lookups

269:
270: /* Cursor for fetching meaning of disability reason */
271: CURSOR csr_get_dis_meaning (l_lookup_code varchar2) IS
272: SELECT meaning
273: FROM hr_lookups
274: WHERE lookup_type = 'DISABILITY_REASON'
275: and lookup_code = l_lookup_code
276: and enabled_flag = 'Y';
277:

Line 288: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl

284:
285: /* Cursor for fetching person's spouse's qualification details */
286: CURSOR csr_get_spouse_details (l_spouse_person_id number) IS
287: SELECT pq.title , hl.meaning
288: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl
289: WHERE pq.person_id = l_spouse_person_id
290: AND pst.qualification_id = pq.qualification_id
291: AND pst.major = 'Y'
292: AND hl.lookup_type = 'PER_SUBJECTS'

Line 1296: FROM hr_lookups hl

1292:
1293: /* Cursor for fetching the Terminated Employees coming under legal employer*/
1294: CURSOR csr_get_leav_reas (l_code varchar2) IS
1295: SELECT hl.meaning
1296: FROM hr_lookups hl
1297: WHERE hl.lookup_type = 'LEAV_REAS'
1298: AND hl.lookup_code = l_code;
1299:
1300: /* Cursor for fetching the person data */

Line 1310: FROM hr_lookups hl

1306:
1307: /* Cursor for fetching the person's marital status */
1308: CURSOR csr_p_mar_status (l_mar_stat varchar2) IS
1309: SELECT hl.meaning
1310: FROM hr_lookups hl
1311: WHERE hl.lookup_type = 'MAR_STATUS'
1312: AND hl.lookup_code = l_mar_stat
1313: AND hl.enabled_flag = 'Y';
1314:

Line 1359: FROM hr_lookups hl

1355:
1356: /* Cursor for fetching the Bank name */
1357: CURSOR csr_get_bank_name (l_code VARCHAR2) IS
1358: SELECT hl.meaning
1359: FROM hr_lookups hl
1360: WHERE hl.lookup_type = 'AE_BANK_NAMES'
1361: AND hl.lookup_code = l_code
1362: AND hl.enabled_flag = 'Y';
1363:

Line 1367: FROM hr_lookups hl

1363:
1364: /* Cursor for fetching the Branch name */
1365: CURSOR csr_get_branch_name (l_code VARCHAR2) IS
1366: SELECT hl.meaning
1367: FROM hr_lookups hl
1368: WHERE hl.lookup_type = 'AE_BRANCH_NAMES'
1369: AND hl.lookup_code = l_code
1370: AND hl.enabled_flag = 'Y';
1371: