DBA Data[Home] [Help]

APPS.GHR_VALIDATE_PERWSDPO dependencies on GHR_POSITIONS_H_V

Line 661: from GHR_POSITIONS_H_V phv

657: RETURN BOOLEAN IS
658:
659: CURSOR c_phv IS
660: select 1
661: from GHR_POSITIONS_H_V phv
662: where phv.position_id = p_position_id
663: and phv.pa_request_id IS NOT NULL
664: and phv.availability_status_id = 1
665: and phv.effective_start_date = p_effective_end_date+1;

Line 688: from GHR_POSITIONS_H_V phv

684: RETURN BOOLEAN IS
685:
686: CURSOR c_phv IS
687: select 1
688: from GHR_POSITIONS_H_V phv
689: where phv.position_id = p_position_id
690: and phv.pa_request_id IS NOT NULL
691: and phv.availability_status_id = 1
692: and phv.effective_start_date >= p_effective_end_date+1;