DBA Data[Home] [Help]

APPS.HR_DK_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

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

341: 'DK_EMP_GROUP',hoi.org_information2,NULL);
342:
343: cursor get_legal_employer is
344: select segment2
345: from hr_soft_coding_keyflex
346: where soft_coding_keyflex_id = l_scl_id;
347:
348:
349: cursor get_info_from_legal_employer is