APPS.PY_ZA_TX_01032006 SQL Statements

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

Line: 155

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

Line: 162

   SELECT last_day(dbi_SES_DTE)
     INTO nti_CurMthEndDte
     FROM dual;

Line: 558

         SELECT pbt.balance_type_id
           INTO l_BalTypId
           FROM pay_balance_types pbt
          WHERE pbt.balance_name = p_BalNme
           AND  pbt.legislation_code = 'ZA';

Line: 589

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