APPS.AST_UWQ_MLIST_INFO_PKG SQL Statements

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

Line: 55

	SELECT a.notes,
		  a.created_by_name,
		  a.entered_date, --modified with a.entered_date instead of a.creation_date for bug#4177915
		  a.note_type_meaning,
		  a.note_status_meaning,
		  a.source_object_id,
		  a.source_object_code,
		  b.select_id,
		  b.select_name,
		  b.select_details,
		  b.from_table,
		  b.where_clause,
		  tl.name,
		  a.notes_detail_size
	FROM ast_notes_bali_vl a,
		jtf_objects_b b,
		jtf_objects_tl tl
	WHERE (a.note_status <> 'P' or a.created_by = p_fnd_user_id)
		and a.object_code like p_object_code
		and a.object_id = p_object_id
		and a.source_object_code = b.object_code
		and b.object_code = tl.object_code
		and tl.language = userenv('LANG')
	order by a.entered_date desc; --modified with a.entered_date instead of a.creation_date for bug#4177915

Line: 85

	SELECT a.notes,
		  a.created_by_name,
		   a.entered_date, --modified with a.entered_date instead of a.creation_date for bug#4177915
		  a.note_type_meaning,
		  a.note_status_meaning,
		  a.source_object_id,
		  a.source_object_code,
		  b.select_id,
		  b.select_name,
		  b.select_details,
		  b.from_table,
		  b.where_clause,
		  tl.name,
		  a.notes_detail_size
	FROM ast_notes_bali_vl a,
		jtf_objects_b b,
		jtf_objects_tl tl
	WHERE (a.note_status <> 'P' or a.created_by = p_fnd_user_id)
		and a.object_code like p_object_code
		and a.object_id = p_object_id
		and a.source_object_code = b.object_code
		and b.object_code = tl.object_code
		and tl.language = userenv('LANG')
		and trunc(a.creation_date) between trunc(p_from_date) and trunc(sysdate)
	order by a.entered_date desc;  --modified with a.entered_date instead of a.creation_date for bug#4177915

Line: 112

    SELECT party_type
    FROM
    hz_parties
     WHERE party_id = p_party_id;