APPS.OE_VERIFY_PAYMENT_PUB dependencies on DUAL

Line 3412: FROM DUAL ;

3408: --
3409: begin
3410: SELECT TO_CHAR(OE_IPAYMENT_TANGIBLE_S.NEXTVAL)||'_ONT'
3411: INTO l_tangible_id
3412: FROM DUAL ;
3413: end ;
3414: END IF; -- tangible id null
3415:
3416: IF l_debug_level > 0 THEN

Line 3605: FROM DUAL ;

3601: END IF;
3602: --
3603: SELECT TO_CHAR(sysdate, 'HH24:MI')
3604: INTO l_time_of_purchase
3605: FROM DUAL ;
3606:
3607: IF l_debug_level > 0 THEN
3608: oe_debug_pub.add( 'OEXPVPMB: TIME OF PURCHASE AFTER MIDNIGHT HH24:MI IS : '|| L_TIME_OF_PURCHASE ) ;
3609: END IF;

Line 6033: FROM DUAL ;

6029: END IF;
6030: --
6031: SELECT TO_CHAR(sysdate, 'HH24:MI')
6032: INTO l_time_of_purchase
6033: FROM DUAL ;
6034:
6035: IF l_debug_level > 0 THEN
6036: oe_debug_pub.add( 'OEXPVPMB: TIME OF PURCHASE AFTER MIDNIGHT HH24:MI IS : '|| L_TIME_OF_PURCHASE ) ;
6037: END IF;