APPS.PA_AUTOALLOC_UTLS SQL Statements

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

Line: 12

	SELECT BATCH.Request_Id
	FROM	PA_Alloc_Runs_All PA,
		GL_Auto_Alloc_Batch_History Batch
	WHERE	PA.Run_ID = p_allocation_run_id
	AND	Batch.Request_ID > 0
	AND	Batch.Batch_ID = PA.Rule_ID
	AND	Batch.Batch_Type_Code = 'P'
	AND 	Batch.PA_Allocation_Run_ID = p_allocation_run_id;

Line: 48

        SELECT WF.End_Date
        FROM    WF_Items_V WF
        WHERE   WF.Item_Type = 'GLALLOC'
        AND     WF.Item_Key = v_item_key
	AND	WF.root_activity = 'GL_SD_ALLOCATION_PROCESS';