5544: AND ROWNUM < 2 ;
5545:
5546: CURSOR LTV2 IS
5547: SELECT PROJECT_ID, TASK_ID
5548: FROM WIP_FLOW_SCHEDULES
5549: WHERE WIP_ENTITY_ID = p_ltv_trx_src_id
5550: AND ROWNUM < 2 ;
5551:
5552: l_ltv_project_ref_enabled NUMBER := 0 ;
14284:
14285:
14286: /*+--------------------------------------------------------------+
14287: | The global gi_flow_schedule will be '1' (or true) for |
14288: | WIP flow schedules ONLY. |
14289: +--------------------------------------------------------------+ */
14290: BEGIN
14291: SELECT DECODE(UPPER(FLOW_SCHEDULE),'Y', 1, 0)
14292: INTO gi_flow_schedule