DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 347: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

343: where assignment_id = p_assignment_id;
344:
345: cursor get_info_from_scl is
346: select lookups.meaning
347: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
348: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
349: and lookups.lookup_type=l_information_code
350: and lookups.enabled_flag = 'Y'
351: and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',scl.segment5,

Line 383: from hr_soft_coding_keyflex

379: and hoi.org_information1 = 'HR_ORG';
380:
381: cursor get_local_unit is
382: select segment2
383: from hr_soft_coding_keyflex
384: where soft_coding_keyflex_id = l_scl_id;
385:
386:
387: cursor get_info_from_local_unit is

Line 416: from HR_SOFT_CODING_KEYFLEX scl

412: where organization_id = l_organization_id;
413:
414: cursor get_info_from_scl_awh is
415: select scl.segment10
416: from HR_SOFT_CODING_KEYFLEX scl
417: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id;
418:
419:
420: cursor get_info_from_org_awh is