APPS.PY_ZA_TX_01032002 SQL Statements

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

Line: 162

   SELECT trunc(dbi_SES_DTE,'Month')
     INTO nti_CurMthStrtDte
     FROM dual;

Line: 170

   SELECT last_day(dbi_SES_DTE)
     INTO nti_CurMthEndDte
     FROM dual;

Line: 565

         SELECT pbt.balance_type_id
           INTO l_BalTypId
           FROM pay_balance_types pbt
          WHERE pbt.balance_name = p_BalNme;

Line: 602

         SELECT pbt.balance_type_id
           INTO l_BalTypId
           FROM pay_balance_types pbt
          WHERE pbt.balance_name = p_BalNme;