DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on HR_GENERAL

Line 366: SELECT HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status

362: and fnd_date.canonical_to_date(AEI_INFORMATION2);
363: --End Bug# 9898968
364: --Begin Bug# 11781477
365: CURSOR c_get_pos_avl_status (p_position_id number,g_effective_date DATE) IS
366: SELECT HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
367: FROM hr_all_positions_f hap
368: WHERE g_effective_date BETWEEN hap.effective_start_date
369: AND hap.effective_end_date
370: AND hap.position_id=p_position_id;