5166: AND ROWNUM < 2 ;
5167:
5168: CURSOR LTV2 IS
5169: SELECT PROJECT_ID, TASK_ID
5170: FROM WIP_FLOW_SCHEDULES
5171: WHERE WIP_ENTITY_ID = p_ltv_trx_src_id
5172: AND ROWNUM < 2 ;
5173:
5174: l_ltv_project_ref_enabled NUMBER := 0 ;
13713:
13714:
13715: /*+--------------------------------------------------------------+
13716: | The global gi_flow_schedule will be '1' (or true) for |
13717: | WIP flow schedules ONLY. |
13718: +--------------------------------------------------------------+ */
13719: BEGIN
13720: SELECT DECODE(UPPER(FLOW_SCHEDULE),'Y', 1, 0)
13721: INTO gi_flow_schedule