[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;