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 1138: FROM DUAL;

1134:
1135: IF (l_pricing_effective_date IS NULL) THEN
1136: SELECT sysdate
1137: INTO l_pricing_effective_date
1138: FROM DUAL;
1139: END IF;
1140:
1141: SELECT
1142: decode(p_expiration_period_uom_code,

Line 1156: FROM dual;

1152: + p_number_expiration_periods/1440,
1153: nvl(p_expiration_period_start_date,l_pricing_effective_date)
1154: + p_number_expiration_periods)
1155: INTO p_expiration_period_end_date
1156: FROM dual;
1157:
1158: END IF;
1159:
1160: EXCEPTION