APPS.CSP_PICK_UTILS dependencies on CSP_SAFETY_FACTORS

Line 1863: From CSP_SAFETY_FACTORS

1859: p_Safety_Stock_Flag Varchar2,
1860: p_Asl_Flag Varchar2) RETURN NUMBER Is
1861: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
1862: Select SAFETY_FACTOR
1863: From CSP_SAFETY_FACTORS
1864: Where EXPOSURES = p_Exp
1865: And SERVICE_LEVEL = p_SL;
1866:
1867: Cursor c_factor_Minmax Is

Line 1869: From CSP_SAFETY_FACTORS;

1865: And SERVICE_LEVEL = p_SL;
1866:
1867: Cursor c_factor_Minmax Is
1868: Select MIN(Exposures) , MAX(Exposures)
1869: From CSP_SAFETY_FACTORS;
1870:
1871: l_min Number;
1872: l_max Number;
1873: l_Safety_factor Number;

Line 1954: From CSP_SAFETY_FACTORS

1950: p_Asl_Flag Varchar2) RETURN NUMBER Is
1951:
1952: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
1953: Select SAFETY_FACTOR
1954: From CSP_SAFETY_FACTORS
1955: Where EXPOSURES = p_Exp
1956: And SERVICE_LEVEL = p_SL;
1957:
1958: Cursor c_factor_Minmax Is

Line 1960: From CSP_SAFETY_FACTORS;

1956: And SERVICE_LEVEL = p_SL;
1957:
1958: Cursor c_factor_Minmax Is
1959: Select MIN(Exposures) , MAX(Exposures)
1960: From CSP_SAFETY_FACTORS;
1961:
1962: l_min Number;
1963: l_max Number;
1964: l_Safety_factor Number;

Line 2041: From CSP_SAFETY_FACTORS

2037: p_Asl_Flag Varchar2) RETURN NUMBER Is
2038:
2039: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
2040: Select SAFETY_FACTOR
2041: From CSP_SAFETY_FACTORS
2042: Where EXPOSURES = p_Exp
2043: And SERVICE_LEVEL = p_SL;
2044:
2045: Cursor c_factor_Minmax Is

Line 2047: From CSP_SAFETY_FACTORS;

2043: And SERVICE_LEVEL = p_SL;
2044:
2045: Cursor c_factor_Minmax Is
2046: Select MIN(Exposures) , MAX(Exposures)
2047: From CSP_SAFETY_FACTORS;
2048:
2049: l_min Number;
2050: l_max Number;
2051: l_Safety_factor Number;

Line 2128: From CSP_SAFETY_FACTORS

2124: p_Asl_Flag Varchar2) RETURN NUMBER Is
2125:
2126: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
2127: Select SAFETY_FACTOR
2128: From CSP_SAFETY_FACTORS
2129: Where EXPOSURES = p_Exp
2130: And SERVICE_LEVEL = p_SL;
2131:
2132: Cursor c_factor_Minmax Is

Line 2134: From CSP_SAFETY_FACTORS;

2130: And SERVICE_LEVEL = p_SL;
2131:
2132: Cursor c_factor_Minmax Is
2133: Select MIN(Exposures) , MAX(Exposures)
2134: From CSP_SAFETY_FACTORS;
2135:
2136: l_min Number;
2137: l_max Number;
2138: l_Safety_factor Number;

Line 2195: From CSP_SAFETY_FACTORS

2191: p_Safety_Stock_Flag Varchar2,
2192: p_Asl_Flag Varchar2) RETURN NUMBER Is
2193: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
2194: Select SAFETY_FACTOR
2195: From CSP_SAFETY_FACTORS
2196: Where EXPOSURES = p_Exp
2197: And SERVICE_LEVEL = p_SL;
2198:
2199: Cursor c_factor_Minmax Is

Line 2201: From CSP_SAFETY_FACTORS;

2197: And SERVICE_LEVEL = p_SL;
2198:
2199: Cursor c_factor_Minmax Is
2200: Select MIN(Exposures) , MAX(Exposures)
2201: From CSP_SAFETY_FACTORS;
2202:
2203: l_min Number;
2204: l_max Number;
2205: l_Safety_factor Number;