APPS.HRI_OPL_PERSON_TYPE_CTGRY dependencies on STANDARD

Line 251: hr_standard_lookups lvl2

247: ,lvl2.lookup_code wkth_lvl2_code
248: ,lvl1.lookup_code wkth_lvl1_code
249: ,wktyp.lookup_code wkth_wktyp_code
250: FROM
251: hr_standard_lookups lvl2
252: ,hr_standard_lookups lvl1
253: ,hr_standard_lookups wktyp
254: WHERE lvl2.lookup_type = ''HRI_CL_WKTH_LVL2''
255: AND lvl1.lookup_type = ''HRI_CL_WKTH_LVL1''

Line 252: ,hr_standard_lookups lvl1

248: ,lvl1.lookup_code wkth_lvl1_code
249: ,wktyp.lookup_code wkth_wktyp_code
250: FROM
251: hr_standard_lookups lvl2
252: ,hr_standard_lookups lvl1
253: ,hr_standard_lookups wktyp
254: WHERE lvl2.lookup_type = ''HRI_CL_WKTH_LVL2''
255: AND lvl1.lookup_type = ''HRI_CL_WKTH_LVL1''
256: AND wktyp.lookup_type = ''HRI_CL_WKTH_WKTYP''

Line 253: ,hr_standard_lookups wktyp

249: ,wktyp.lookup_code wkth_wktyp_code
250: FROM
251: hr_standard_lookups lvl2
252: ,hr_standard_lookups lvl1
253: ,hr_standard_lookups wktyp
254: WHERE lvl2.lookup_type = ''HRI_CL_WKTH_LVL2''
255: AND lvl1.lookup_type = ''HRI_CL_WKTH_LVL1''
256: AND wktyp.lookup_type = ''HRI_CL_WKTH_WKTYP''
257: ) tab

Line 306: hr_standard_lookups lvl1

302: ,wktyp.lookup_code wkth_wktyp_sk_fk
303: ,lvl1.lookup_code wkth_lvl1_code
304: ,wktyp.lookup_code wkth_wktyp_code
305: FROM
306: hr_standard_lookups lvl1
307: ,hr_standard_lookups wktyp
308: WHERE lvl1.lookup_type = ''HRI_CL_WKTH_LVL1''
309: AND wktyp.lookup_type = ''HRI_CL_WKTH_WKTYP''
310: ) tab

Line 307: ,hr_standard_lookups wktyp

303: ,lvl1.lookup_code wkth_lvl1_code
304: ,wktyp.lookup_code wkth_wktyp_code
305: FROM
306: hr_standard_lookups lvl1
307: ,hr_standard_lookups wktyp
308: WHERE lvl1.lookup_type = ''HRI_CL_WKTH_LVL1''
309: AND wktyp.lookup_type = ''HRI_CL_WKTH_WKTYP''
310: ) tab
311: WHERE EXISTS

Line 354: FROM hr_standard_lookups hrl

350: WHERE dim.employment_category_code <> 'NA_EDW'
351: AND dim.prsntyp_sk_pk <> -1
352: AND dim.employment_category_code NOT IN
353: (SELECT hrl.lookup_code
354: FROM hr_standard_lookups hrl
355: WHERE hrl.lookup_type IN ('EMP_CAT','CWK_ASG_CATEGORY')
356: AND hrl.enabled_flag = 'Y');
357:
358: ELSE