APPS.IEX_PAYMENTS_BATCH_PUB SQL Statements

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

Line: 45

		select max(ACTUAL_START_DATE)
		from FND_CONC_REQ_SUMMARY_V
		where PROGRAM_SHORT_NAME = 'IEX_PROCESS_PAYMENTS'
                and (program_application_id = 695 or program_application_id = 222) -- fixed a perf bug 4930381
		and request_id <> p_request_id;

Line: 53

		select ACTUAL_START_DATE
		from FND_CONC_REQ_SUMMARY_V
		where PROGRAM_SHORT_NAME = 'IEX_PROCESS_PAYMENTS'
                and (program_application_id = 695 or program_application_id = 222) -- fixed a perf bug 4930381
		and request_id = p_request_id;

Line: 157

		vSQL := 'SELECT PSA.PAYMENT_SCHEDULE_ID ' ||
			'FROM ' ||
			'AR_PAYMENT_SCHEDULES PSA, ' ||
			'IEX_DELINQUENCIES DEL ' ||
			'WHERE  ' ||
			'(PSA.ACTUAL_DATE_CLOSED BETWEEN trunc(:P_START_DATE) AND trunc(:P_END_DATE)) AND ' ||
			'PSA.STATUS = ''CL'' AND ' ||
			'DEL.PAYMENT_SCHEDULE_ID = PSA.PAYMENT_SCHEDULE_ID AND ' ||
			'DEL.STATUS = ''OPEN''';

Line: 171

		vSQL := 'SELECT PSA.PAYMENT_SCHEDULE_ID ' ||
			'FROM ' ||
			'AR_PAYMENT_SCHEDULES PSA, ' ||
			'IEX_DELINQUENCIES DEL ' ||
			'WHERE  ' ||
			'trunc(PSA.ACTUAL_DATE_CLOSED) <= trunc(:P_END_DATE) AND ' ||
			'PSA.STATUS = ''CL'' AND ' ||
			'DEL.PAYMENT_SCHEDULE_ID = PSA.PAYMENT_SCHEDULE_ID AND ' ||
			'DEL.STATUS <> ''CLOSED''';