DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VWP_STAGES_B

Line 9963: FROM ahl_vwp_stages_b

9959: -- To validate the passed stage id
9960: Cursor val_visit_stage (x_visit_id IN NUMBER, x_stage_id IN NUMBER)
9961: IS
9962: SELECT 'X'
9963: FROM ahl_vwp_stages_b
9964: WHERE visit_id = x_visit_id
9965: AND stage_id = x_stage_id;
9966:
9967: -- To validate the passed visit id

Line 9983: FROM ahl_vwp_stages_b

9979:
9980: -- TCHIMIRA :: 04-May-2012 :: Bug 14009280 :: START
9981: Cursor get_stage_dates (c_stage_id IN NUMBER) IS
9982: SELECT planned_start_date, planned_end_date
9983: FROM ahl_vwp_stages_b
9984: WHERE stage_id = c_stage_id;
9985:
9986: Cursor get_visit_dates (c_visit_id IN NUMBER) IS
9987: SELECT start_date_time, close_date_time