DBA Data[Home] [Help]

APPS.GHR_VALIDATE_PERWSDPO dependencies on GHR_POSITIONS_H_V

Line 592: from GHR_POSITIONS_H_V phv

588: RETURN BOOLEAN IS
589:
590: CURSOR c_phv IS
591: select 1
592: from GHR_POSITIONS_H_V phv
593: where phv.position_id = p_position_id
594: and phv.pa_request_id IS NOT NULL
595: and phv.availability_status_id = 1
596: and phv.effective_start_date = p_effective_end_date+1;

Line 619: from GHR_POSITIONS_H_V phv

615: RETURN BOOLEAN IS
616:
617: CURSOR c_phv IS
618: select 1
619: from GHR_POSITIONS_H_V phv
620: where phv.position_id = p_position_id
621: and phv.pa_request_id IS NOT NULL
622: and phv.availability_status_id = 1
623: and phv.effective_start_date >= p_effective_end_date+1;