APPS.SSP_ERN_SHD SQL Statements

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

Line: 62

	select	earnings_calculations_id,
		object_version_number,
		person_id,
		effective_date,
		average_earnings_amount,
		user_entered,
		payment_periods
	  from	ssp_earnings_calculations
	 where	earnings_calculations_id = p_earnings_calculations_id;

Line: 145

    select earnings_calculations_id,
	   object_version_number,
	   person_id,
	   effective_date,
	   average_earnings_amount,
	   user_entered,
	   payment_periods
    from   ssp_earnings_calculations
    where  earnings_calculations_id = p_earnings_calculations_id
    for	update nowait;