DBA Data[Home] [Help]

APPS.PQH_WKS_ERROR_CHK dependencies on HR_ALL_POSITIONS_F

Line 898: FROM hr_all_positions_f pos, pqh_worksheets wks, pqh_budgets bud

894:
895: CURSOR csr_pos_availability(p_position_id l_worksheet_details_rec.position_id%type,
896: p_worksheet_id l_worksheet_details_rec.worksheet_id%type) IS
897: SELECT pos.availability_status_id
898: FROM hr_all_positions_f pos, pqh_worksheets wks, pqh_budgets bud
899: WHERE pos.position_id = p_position_id
900: AND wks.worksheet_id = p_worksheet_id
901: AND wks.budget_id = bud.budget_id
902: AND pos.effective_start_date < bud.budget_end_date