APPS.PJI_REP_PRF_DFLT_PARAMS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

, x_page_links_selection         OUT NOCOPY VARCHAR2
, x_from_period                  OUT NOCOPY NUMBER
, x_to_period                    OUT NOCOPY NUMBER
, x_project_type				 OUT NOCOPY VARCHAR2
, x_ptc_flag					 OUT NOCOPY VARCHAR2
, p_prg_rollup					 IN OUT NOCOPY VARCHAR2
, x_Return_Status                OUT NOCOPY VARCHAR2
, x_Msg_Count                    OUT NOCOPY NUMBER
, x_Msg_Data                     OUT NOCOPY VARCHAR2
, p_currency_record_type				 VARCHAR2 DEFAULT NULL
, p_period_type					 VARCHAR2 DEFAULT NULL
, p_as_of_date					 NUMBER DEFAULT NULL
, p_cstbudget_plan_type_id		 NUMBER DEFAULT NULL
, p_cstforecast_plan_type_id	 NUMBER DEFAULT NULL
, p_revbudget_plan_type_id		 NUMBER DEFAULT NULL
, p_revforecast_plan_type_id	 NUMBER DEFAULT NULL
, p_calling_type				 VARCHAR DEFAULT NULL
, x_fbs_expansion_lvl                    OUT NOCOPY NUMBER
) IS

l_context_plan_version NUMBER;

Line: 204

    x_page_links_selection := 'PROJ_OVERVIEW';

Line: 233

		SELECT elm.proj_element_id
		INTO x_wbs_element_id
		FROM pa_proj_element_versions elm
		WHERE elm.element_version_id = x_wbs_version_id;