DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SEARCH_PKG dependencies on DUAL

Line 461: from dual;

457: l_status_code := get_timecard_status_code(bb_id,bb_ovn);
458:
459: -- Bug 2486271; Changed hr_general.decode_lookup to hr_bis.bis_decode_lookup.
460: select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
461: from dual;
462: -- select hr_bis.bis_decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
463: -- from dual;
464:
465: return l_status_meaning;

Line 463: -- from dual;

459: -- Bug 2486271; Changed hr_general.decode_lookup to hr_bis.bis_decode_lookup.
460: select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
461: from dual;
462: -- select hr_bis.bis_decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
463: -- from dual;
464:
465: return l_status_meaning;
466:
467:

Line 495: FROM DUAL

491: (p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
492: ,p_timecard_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
493: ) is
494: SELECT 'Yes'
495: FROM DUAL
496: WHERE EXISTS ( SELECT '1'
497: FROM hxc_time_building_blocks days,
498: hxc_time_building_blocks details,
499: hxc_time_attribute_usages tau,