APPS.AST_NOTE_PACKAGE SQL Statements

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

Line: 53

	select notes_detail
     from jtf_notes_tl
     where jtf_note_id = p_note_id
     and language = userenv('LANG');

Line: 87

  select a.meaning
  from ar_lookups a, hz_parties p
  where p.party_id = p_object_id
  and a.lookup_code = p.party_type
  and a.lookup_type = 'PARTY_TYPE';

Line: 107

	p_select_id VARCHAR2,
	p_select_name VARCHAR2,
	p_select_details VARCHAR2,
	p_from_table VARCHAR2,
	p_where_clause VARCHAR2,
	p_object_id NUMBER)
return VARCHAR2 is
  l_sql_statement VARCHAR2(2000);

Line: 120

  if p_from_table is not null and p_select_id is not null and p_object_id is not null then
     if p_select_name is not null then
          l_sql_statement := 'SELECT ' || p_select_name || ' ';

Line: 124

     if p_select_details is not null then
          if l_sql_statement is not null then
               l_sql_statement := l_sql_statement || ' || '' - '' || ';

Line: 128

               l_sql_statement := 'SELECT ';

Line: 130

          l_sql_statement := l_sql_statement || p_select_details || ' ';

Line: 134

          l_sql_statement := l_sql_statement || 'WHERE ' || p_select_id || ' = :p_object_id ';