APPS.PA_BILLING_VALIDATE 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: 25

	SELECT  event_type_classification
	INTO	classification
	FROM	pa_event_types
	WHERE	event_type = X2_event_type;

Line: 53

	SELECT 	'Valid Proj/Task/Assgn'
	INTO	dummy
	FROM	pa_tasks t, pa_projects p
	WHERE	t.project_id = X2_project_id
	AND	t.top_task_id = nvl(X2_top_task_id, t.top_task_id)
	AND	t.project_id = p.project_id
	AND	rownum = 1;

Line: 73

	SELECT 	'Valid Org'
	INTO	dummy
	FROM	hr_organization_units
	WHERE	organization_id = X2_organization_id;