APPS.PA_BILLING_VALUES 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 decode(project_level_funding_flag,
			'Y', 'PROJECT',
			'N','TASK',
			'NO FUNDING')
	INTO	funding
	FROM	pa_projects
	WHERE	project_id = X2_project_id;

Line: 41

		SELECT 	p.carrying_out_organization_id
		INTO	XO_organization_id
		FROM	pa_projects p
		WHERE	p.project_id = X2_project_id;

Line: 46

		SELECT 	t.carrying_out_organization_id
		INTO	XO_organization_id
		FROM	pa_tasks t
		WHERE	t.task_id = X2_top_task_id;

Line: 67

	SELECT  be.default_event_description, be.default_event_type
	INTO	XO_event_description, XO_event_type
	FROM	pa_billing_extensions be,
		pa_billing_assignments bea
	WHERE	bea.billing_assignment_id = X2_billing_assignment_id
	AND	bea.billing_extension_id = be.billing_extension_id;

Line: 85

	SELECT meaning
	INTO   message
	FROM   pa_lookups
	WHERE  lookup_type = 'BILLING EXTENSION MESSAGES'
	AND    lookup_code = X2_message_code;