APPS.CTO_WORKFLOW_API_PK dependencies on DUAL

Line 651: FROM DUAL;

647: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
648: NULL,
649: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
650: INTO l_original_org_id
651: FROM DUAL;
652:
653:
654:
655: change_status_batch (

Line 3691: from dual;

3687:
3688: l_stmt_num :=70;
3689: select decode(l_make_flag,'Y',1,0)+decode(l_buy_fg,'Y',1,0)+decode(l_xfer_fg,'Y',1,0)
3690: into l_hetro
3691: from dual;
3692:
3693: l_stmt_num:=80;
3694: If l_onhand_fg = 'Y' and
3695: l_rsv_rec(l_inv_src_id).primary_reservation_quantity >= p_ordered_quantity Then