eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_COUPON_PVT dependencies on DUAL

Line 203: FROM dual;

199: SELECT QP_GENERATED_COUPON_NO_S.nextval,
200: QP_COUPONS_S.nextval
201: INTO l_generated_coupon_number,
202: x_coupon_id
203: FROM dual;
204:
205: IF l_debug = FND_API.G_TRUE THEN
206: QP_PREQ_GRP.engine_debug ('coupon_id going to QP_COUPONS table (QP_COUPONS_S.nextval): '||x_coupon_id);
207: QP_PREQ_GRP.engine_debug ('l_generated_coupon_number(QP_GENERATED_COUPON_NO_S.nextval): '||l_generated_coupon_number);

Line 1171: FROM DUAL;

1167:
1168: IF (l_pricing_effective_date IS NULL) THEN
1169: SELECT sysdate
1170: INTO l_pricing_effective_date
1171: FROM DUAL;
1172: END IF;
1173:
1174: SELECT
1175: decode(p_expiration_period_uom_code,

Line 1189: FROM dual;

1185: + p_number_expiration_periods/1440,
1186: nvl(p_expiration_period_start_date,l_pricing_effective_date)
1187: + p_number_expiration_periods)
1188: INTO p_expiration_period_end_date
1189: FROM dual;
1190:
1191: END IF;
1192:
1193: EXCEPTION