APPS.PY_ZA_TX_01032009 SQL Statements

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

Line: 289

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

Line: 296

   SELECT last_day(dbi_SES_DTE)
     INTO nti_CurMthEndDte
     FROM dual;

Line: 877

         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: 908

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

Line: 5632

       select paei.AEI_INFORMATION8
       into   trc_PenBasis
       from   per_assignment_extra_info  paei
       where  paei.assignment_id    = con_ASG_ID
       and    paei.information_type = 'ZA_SPECIFIC_INFO';