APPS.AMW_ASSERTIONS_PKG SQL Statements

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

Line: 18

   select count(*)
   into n
   from amw_account_assertions
   where natural_account_id = p_natural_account_id
   and   assertion_code = p_assertion_code;

Line: 48

   select count(*)
   into n
   from amw_account_assertions
   where natural_account_id = p_natural_account_id
   and   assertion_code = p_assertion_code;

Line: 54

   select meaning
   into yes
   from fnd_lookups
   where lookup_type='YES_NO'
   and lookup_code='Y';

Line: 60

   select meaning
   into no
   from fnd_lookups
   where lookup_type='YES_NO'
   and lookup_code='N';

Line: 84

                   p_select_flag         IN         VARCHAR2,
                   p_natural_account_id  IN         NUMBER,
                   p_assertion_code      IN         VARCHAR2
)
IS
      l_creation_date         date;

Line: 91

      l_last_update_date      date;

Line: 92

      l_last_updated_by       number;

Line: 93

      l_last_update_login     number;

Line: 98

      delete from amw_account_assertions
      where natural_account_id = p_natural_account_id
	  and   assertion_code = p_assertion_code;

Line: 102

      if (p_select_flag = 'Y') then

          l_creation_date := SYSDATE;

Line: 106

          l_last_update_date := SYSDATE;

Line: 107

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 108

          l_last_update_login := FND_GLOBAL.USER_ID;

Line: 111

          select amw_account_assertion_s.nextval into l_account_assertion_id from dual;

Line: 113

          insert into amw_account_assertions (account_assertion_id,
                                              natural_account_id,
                                              assertion_code,
                                              creation_date,
                                              created_by,
                                              last_update_date,
                                              last_updated_by,
                                              last_update_login,
                                              object_version_number)
          values (l_account_assertion_id,
                  p_natural_account_id,
                  p_assertion_code,
                  l_creation_date,
                  l_created_by,
                  l_last_update_date,
                  l_last_updated_by,
                  l_last_update_login,
                  l_object_version_number);