DBA Data[Home] [Help]

APPS.HR_DK_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 371: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

367: where assignment_id = p_assignment_id;
368:
369: cursor get_info_from_scl is
370: select lookups.meaning
371: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
372: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
373: and lookups.lookup_type=l_information_code
374: and lookups.enabled_flag = 'Y'
375: and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',scl.segment3,

Line 391: from hr_soft_coding_keyflex

387: 'DK_EMP_GROUP',hoi.org_information2,NULL);
388:
389: cursor get_legal_employer is
390: select segment2
391: from hr_soft_coding_keyflex
392: where soft_coding_keyflex_id = l_scl_id;
393:
394:
395: cursor get_info_from_legal_employer is