DBA Data[Home] [Help]

APPS.PJI_REP_WP_DFLT_PARAMS SQL Statements

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

Line: 313

	select 	to_char(start_date,'j')
	into 	x_report_period
	from 	pji_time_cal_period
	where 	l_actual_summ_date -- sysdate
	between start_date
	and 	end_date
	and 	calendar_id = x_calendar_id;
Line: 413

select 	project_currency_code,
	projfunc_currency_code
into	l_prj_curr,
	l_pfc_curr
from	pa_projects
where	project_id = p_project_id;