DBA Data[Home] [Help]

APPS.OKS_BILLING_PROFILES_PUB dependencies on DUAL

Line 787: -- SELECT (f_target_qty - ROUND(f_target_qty)) INTO l_round_quantity FROM DUAL ;

783: l_round_quantity NUMBER;
784:
785: BEGIN
786: -- commented and changed select statement for bug 3497141
787: -- SELECT (f_target_qty - ROUND(f_target_qty)) INTO l_round_quantity FROM DUAL ;
788:
789: SELECT (f_target_qty - f_target_qty) INTO l_round_quantity FROM DUAL ;
790: -- end comment and change for bug 3497141
791: RETURN l_round_quantity;

Line 789: SELECT (f_target_qty - f_target_qty) INTO l_round_quantity FROM DUAL ;

785: BEGIN
786: -- commented and changed select statement for bug 3497141
787: -- SELECT (f_target_qty - ROUND(f_target_qty)) INTO l_round_quantity FROM DUAL ;
788:
789: SELECT (f_target_qty - f_target_qty) INTO l_round_quantity FROM DUAL ;
790: -- end comment and change for bug 3497141
791: RETURN l_round_quantity;
792:
793: END round_quantity;