APPS.OE_VERIFY_PAYMENT_PUB dependencies on DUAL

Line 3339: FROM DUAL ;

3335: --
3336: begin
3337: SELECT TO_CHAR(OE_IPAYMENT_TANGIBLE_S.NEXTVAL)||'_ONT'
3338: INTO l_tangible_id
3339: FROM DUAL ;
3340: end ;
3341: END IF; -- tangible id null
3342:
3343: IF l_debug_level > 0 THEN

Line 3532: FROM DUAL ;

3528: END IF;
3529: --
3530: SELECT TO_CHAR(sysdate, 'HH24:MI')
3531: INTO l_time_of_purchase
3532: FROM DUAL ;
3533:
3534: IF l_debug_level > 0 THEN
3535: oe_debug_pub.add( 'OEXPVPMB: TIME OF PURCHASE AFTER MIDNIGHT HH24:MI IS : '|| L_TIME_OF_PURCHASE ) ;
3536: END IF;

Line 5869: FROM DUAL ;

5865: END IF;
5866: --
5867: SELECT TO_CHAR(sysdate, 'HH24:MI')
5868: INTO l_time_of_purchase
5869: FROM DUAL ;
5870:
5871: IF l_debug_level > 0 THEN
5872: oe_debug_pub.add( 'OEXPVPMB: TIME OF PURCHASE AFTER MIDNIGHT HH24:MI IS : '|| L_TIME_OF_PURCHASE ) ;
5873: END IF;