DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on HR_LOOKUPS

Line 366: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

362: where assignment_id = p_assignment_id;
363:
364: cursor get_info_from_scl is
365: select lookups.meaning
366: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
367: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
368: and lookups.lookup_type=l_information_code
369: and lookups.enabled_flag = 'Y'
370: and lookups.lookup_code = decode(l_information_code,'FI_EMPLOYMENT_TYPE',scl.segment3,

Line 389: from hr_organization_information hoi , hr_lookups lookups

385:
386:
387: cursor get_info_from_local_unit is
388: select lookups.meaning
389: from hr_organization_information hoi , hr_lookups lookups
390: where hoi.organization_id = l_org_id
391: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
392: and lookups.lookup_type = l_information_code
393: and lookups.enabled_flag = 'Y'

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

405: and hoi2.organization_id = hoi1.organization_id;
406:
407: cursor get_info_from_org is
408: select lookups.meaning
409: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
410: where hou.organization_id = l_organization_id
411: and hou.organization_id = hoi.organization_id
412: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
413: and lookups.lookup_type = l_information_code