APPS.AHL_VWP_RULES_PVT dependencies on AHL_WBS_RULES

Line 4308: FROM ahl_wbs_rules

4304:
4305: --To fetch the WBS rule IDs if any of the passed route attributes match with pre-attributes of a wbs rule.
4306: Cursor get_rule_id (p_route_no IN VARCHAR2, p_route_type IN VARCHAR2, p_system_code IN VARCHAR2, p_process_code IN VARCHAR2) IS
4307: SELECT rule_id
4308: FROM ahl_wbs_rules
4309: WHERE NVL(PRE_ROUTE_NUMBER,'X') = NVL2(PRE_ROUTE_NUMBER,p_route_no, 'X')
4310: AND NVL(PRE_ROUTE_TYPE_CODE,'X') = NVL2(PRE_ROUTE_TYPE_CODE,p_route_type, 'X')
4311: AND NVL(PRE_SYSTEM_CODE,'X') = NVL2(PRE_SYSTEM_CODE,p_system_code, 'X')
4312: AND NVL(PRE_PROCESS_CODE,'X') = NVL2(PRE_PROCESS_CODE,p_process_code, 'X');

Line 4317: FROM ahl_wbs_rules

4313:
4314: --To fetch the WBS post route attributes of the passed rule id.
4315: Cursor get_post_route_attr (p_rule_id IN NUMBER) IS
4316: SELECT POST_ROUTE_NUMBER, POST_ROUTE_TYPE_CODE, POST_SYSTEM_CODE, POST_PROCESS_CODE
4317: FROM ahl_wbs_rules
4318: WHERE RULE_ID = p_rule_id;
4319:
4320: --To match the post route attributes with the route attributes of all the tasks that fall under the same stage.
4321: Cursor get_task_id (p_stage_id IN NUMBER, p_route_no IN VARCHAR2, p_route_type IN VARCHAR2, p_system_code IN VARCHAR2, p_process_code IN VARCHAR2) IS