APPS.PJI_PMV_DFLT_PARAMS_PVT dependencies on PJI_SYSTEM_SETTINGS

Line 82: FROM PJI_SYSTEM_SETTINGS;

78: DFLT_PRJPRF_CYCLE_ID,
79: DFLT_PRJCST_PERIOD_TYPE,
80: DFLT_PRJCST_CYCLE_ID
81: INTO InitialValues
82: FROM PJI_SYSTEM_SETTINGS;
83:
84: select MONTH_ID,
85: ENT_PERIOD_ID,
86: ENT_QTR_ID,

Line 102: 'Parametrization table contains no data. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');

98: WHEN NO_DATA_FOUND THEN
99: -- Bug 5391217 If the call is from Discoverer ignore the exception
100: IF p_Calling_Context IS NULL THEN
101: raise_application_error(-20010,
102: 'Parametrization table contains no data. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');
103: ELSE
104: RETURN;
105: END IF;
106: WHEN TOO_MANY_ROWS

Line 109: 'Parametrization table contains more than 1 row. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');

105: END IF;
106: WHEN TOO_MANY_ROWS
107: THEN
108: raise_application_error(-20010,
109: 'Parametrization table contains more than 1 row. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');
110:
111: END InitEnvironment ;
112:
113: -- ********************************************************

Line 241: pji_system_settings syssetting

237: BEGIN
238: SELECT prjpip.ID into G_Period_Type_ID
239: -- ,prjbab.value
240: FROM
241: pji_system_settings syssetting
242: , pji_period_types_v prjpip
243: , pji_period_types_v prjbab
244: WHERE
245: prjbab.global_disp_flag = 0