APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_STAGE_LINKS

Line 15422: SELECT 'X' FROM ahl_stage_links link

15418:
15419: -- Get the passed stage child id and all its successive child stages
15420: CURSOR c_get_child_stages(p_subject_id IN NUMBER)
15421: IS
15422: SELECT 'X' FROM ahl_stage_links link
15423: WHERE EXISTS (SELECT 'X' FROM ahl_vwp_stages_b WHERE stage_id = link.object_id and stage_status_code = 'PLANNING')
15424: START WITH link.subject_id = p_subject_id
15425: CONNECT BY PRIOR link.object_id = link.subject_id;
15426: l_dummy VARCHAR2(1);