APPS.HR_FI_UTILITY dependencies on HR_LOOKUPS

Line 322: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

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

Line 345: from hr_organization_information hoi , hr_lookups lookups

341:
342:
343: cursor get_info_from_local_unit is
344: select lookups.meaning
345: from hr_organization_information hoi , hr_lookups lookups
346: where hoi.organization_id = l_org_id
347: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
348: and lookups.lookup_type = l_information_code
349: and lookups.enabled_flag = 'Y'

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

361: and hoi2.organization_id = hoi1.organization_id;
362:
363: cursor get_info_from_org is
364: select lookups.meaning
365: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
366: where hou.organization_id = l_organization_id
367: and hou.organization_id = hoi.organization_id
368: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
369: and lookups.lookup_type = l_information_code