APPS.MRP_MRPRPROP_XMLP_PKG dependencies on DUAL

Line 50: DUAL;

46: SELECT
47: sysdate
48: INTO P_CURRENT_DATE
49: FROM
50: DUAL;
51: SELECT
52: EMPLOYEE_ID
53: INTO P_EMPLOYEE_ID
54: FROM

Line 88: DUAL;

84: SELECT
85: WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL
86: INTO P_WIP_BATCH_ID
87: FROM
88: DUAL;
89: END IF;
90: END;
91: DP_DEMAND_CUTOFF_DATE:=to_char(P_DEMAND_CUTOFF_DATE,DATE_FORMAT);
92: DP_SUPPLY_CUTOFF_DATE:=to_char(P_SUPPLY_CUTOFF_DATE,DATE_FORMAT);

Line 1338: DUAL;

1334: SELECT
1335: SQRT(2 * ANNUAL_DEMAND * COST_RATIO)
1336: INTO REORDER_QTY
1337: FROM
1338: DUAL;
1339: IF (MAX_PT < MIN_ORD_QTY) THEN
1340: MAX_PT := MIN_ORD_QTY;
1341: END IF;
1342: IF (MAX_PT >= REORDER_QTY) THEN

Line 1351: DUAL;

1347: ROUND(REORDER_QTY / FIX_LOT_MULT
1348: ,0)
1349: INTO QUOTIENT
1350: FROM
1351: DUAL;
1352: REORDER_QTY := FIX_LOT_MULT * QUOTIENT;
1353: IF (REORDER_QTY < MAX_PT) THEN
1354: REORDER_QTY := REORDER_QTY + FIX_LOT_MULT;
1355: END IF;

Line 1958: SYS.DUAL;

1954: SELECT
1955: sysdate
1956: INTO L_SYSDATE
1957: FROM
1958: SYS.DUAL;
1959: IF (INCLUDE_NONNET = 1) THEN
1960: L_ONHAND_SOURCE := NULL;
1961: ELSE
1962: L_ONHAND_SOURCE := 2;