DBA Data[Home] [Help]

APPS.PAY_JP_MAGTAPE_PKG SQL Statements

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

Line: 26

		select	max(request_id)
		from	fnd_concurrent_requests	fcr,
			fnd_concurrent_programs	fcp
		where	fcp.application_id = 801
		and	fcp.concurrent_program_name = 'PAYJPMAG'
		and	fcr.program_application_id = fcp.application_id
		and	fcr.concurrent_program_id = fcp.concurrent_program_id
		and	fcr.argument1 = to_char(p_payroll_action_id);