APPS.OE_SYS_PARAMETERS_PVT dependencies on OE_SYS_PARAMETERS_ALL

Line 48: -- from oe_sys_parameters_all

44: -- Start of comments
45: -- API name : Get_Value_From_Db
46: -- Type : Private
47: -- Description : This function will get the parameter value of a system parameter
48: -- from oe_sys_parameters_all
49: -- Parameters :
50: -- IN : p_parameter_Code IN VARCHAR2 Required
51: --
52: -- P_org_id IN NUMBER

Line 63: FROM oe_sys_parameters_all

59: IS
60: /* MOAC_SQL_CHANGE */
61: CURSOR parameter_value IS
62: SELECT parameter_value
63: FROM oe_sys_parameters_all
64: WHERE parameter_code = p_parameter_code
65: AND org_id = p_org_id;
66: /*
67: AND NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB