DBA Data[Home] [Help]

APPS.PA_BILLING_SEQ SQL Statements

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

Line: 8

last_updated_by		NUMBER(15);	   --|
Line: 10

last_update_login	NUMBER(15);        --|Standard Who Columns
Line: 24

	SELECT max(event_num)
	INTO	eventnum
	FROM	pa_events
	WHERE	project_id = X2_project_id
	AND	nvl(task_id,-1) = nvl(X2_task_id,-1);
Line: 47

	SELECT userenv('sessionid')
	INTO   xo_sessionid
	FROM	DUAL;