APPS.HR_DK_UTILITY dependencies on HR_LOOKUPS

Line 325: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

321: where assignment_id = p_assignment_id;
322:
323: cursor get_info_from_scl is
324: select lookups.meaning
325: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
326: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
327: and lookups.lookup_type=l_information_code
328: and lookups.enabled_flag = 'Y'
329: and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',scl.segment3,

Line 334: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups

330: 'DK_EMP_GROUP',scl.segment4,NULL);
331:
332: cursor get_info_from_org is
333: select lookups.meaning
334: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
335: where hou.organization_id = l_organization_id
336: and hou.organization_id = hoi.organization_id
337: and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
338: and lookups.lookup_type = l_information_code

Line 351: from hr_organization_information hoi , hr_lookups lookups

347:
348:
349: cursor get_info_from_legal_employer is
350: select lookups.meaning
351: from hr_organization_information hoi , hr_lookups lookups
352: where hoi.organization_id = l_org_id
353: and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
354: and lookups.lookup_type = l_information_code
355: and lookups.enabled_flag = 'Y'