DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

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 339: from hr_soft_coding_keyflex

335:
336:
337: cursor get_local_unit is
338: select segment2
339: from hr_soft_coding_keyflex
340: where soft_coding_keyflex_id = l_scl_id;
341:
342:
343: cursor get_info_from_local_unit is