APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VST_TYP_STAGE_LINKS

Line 3142: FROM AHL_VST_TYP_STAGE_LINKS

3138:
3139: -- To find previous stage id
3140: CURSOR c_prev_stage_id (p_stage_id IN NUMBER) IS
3141: SELECT subject_id
3142: FROM AHL_VST_TYP_STAGE_LINKS
3143: WHERE object_id = p_stage_id and relation_type = 'BEFORE' ;
3144:
3145: -- To find the stage number for the corresponding stage id
3146: CURSOR c_stage_num (p_stage_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