APPS.INV_UI_ITEM_ATT_LOVS dependencies on DUAL

Line 479: FROM DUAL;

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

Line 510: FROM DUAL;

506:
507: IF p_shelf_life_code = 2 THEN
508: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
509: INTO x_expiration_date
510: FROM DUAL;
511: END IF;
512:
513: --Global Lot ER Start
514: BEGIN

Line 2352: FROM DUAL;

2348: IF x_expiration_date IS NULL THEN
2349: IF p_shelf_life_code = 2 THEN
2350: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
2351: INTO x_expiration_date
2352: FROM DUAL;
2353: END IF;
2354: END IF;
2355:
2356: RETURN;

Line 2362: FROM DUAL;

2358: WHEN NO_DATA_FOUND THEN
2359: IF p_shelf_life_code = 2 THEN
2360: SELECT (SYSDATE + NVL(p_shelf_life_days, 0))
2361: INTO x_expiration_date
2362: FROM DUAL;
2363: END IF;
2364:
2365: RETURN;
2366: END;