APPS.INV_UI_ITEM_ATT_LOVS dependencies on DUAL

Line 450: FROM DUAL;

446: IF x_expiration_date IS NULL THEN
447: IF p_shelf_life_code = 2 THEN
448: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
449: INTO x_expiration_date
450: FROM DUAL;
451: END IF;
452: END IF;
453:
454: RETURN;

Line 477: FROM DUAL;

473:
474: IF p_shelf_life_code = 2 THEN
475: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
476: INTO x_expiration_date
477: FROM DUAL;
478: END IF;
479:
480: RETURN;
481: END;

Line 2265: FROM DUAL;

2261: IF x_expiration_date IS NULL THEN
2262: IF p_shelf_life_code = 2 THEN
2263: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
2264: INTO x_expiration_date
2265: FROM DUAL;
2266: END IF;
2267: END IF;
2268:
2269: RETURN;

Line 2275: FROM DUAL;

2271: WHEN NO_DATA_FOUND THEN
2272: IF p_shelf_life_code = 2 THEN
2273: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
2274: INTO x_expiration_date
2275: FROM DUAL;
2276: END IF;
2277:
2278: RETURN;
2279: END;