APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VISIT_TYPE_STAGES_B

Line 3148: FROM ahl_visit_type_stages_b

3144:
3145: -- To find the stage number for the corresponding stage id
3146: CURSOR c_stage_num (p_stage_id IN NUMBER) IS
3147: SELECT stage_number
3148: FROM ahl_visit_type_stages_b
3149: WHERE visit_type_stage_id = p_stage_id;
3150:
3151: --To fetch all the stages associated to the passed visit type code.
3152: CURSOR get_visit_type_stages (p_visit_type_code IN VARCHAR2, p_visit_id IN NUMBER) IS

Line 3176: FROM ahl_vst_typ_stage_links links, ahl_visit_type_stages_b vt_obj, ahl_visit_type_stages_b vt_sub,

3172:
3173: --To fetch all the stage rules of a stage and get the visit subject and object stage ids corresponding to visit type subject and object stage ids
3174: CURSOR get_stage_rules (p_visit_type_stage_id IN NUMBER, p_visit_id IN NUMBER) IS
3175: SELECT stage_obj.stage_id object_id, stage_sub.stage_id subject_id, links.relation_type
3176: FROM ahl_vst_typ_stage_links links, ahl_visit_type_stages_b vt_obj, ahl_visit_type_stages_b vt_sub,
3177: ahl_vwp_stages_b stage_obj, ahl_vwp_stages_b stage_sub
3178: WHERE links.subject_id = p_visit_type_stage_id
3179: AND links.subject_id = vt_sub.visit_type_stage_id
3180: AND links.object_id = vt_obj.visit_type_stage_id