APPS.PY_ZA_TX_01032005 SQL Statements

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

Line: 75

      J.N. Louw   24/08/2005 115.9   4566053 Updated
      J.N. Louw   17/08/2005 115.8   4346920 Updated
      R.V. Pahune 05/08/2005 115.7   4346920 Balance feed enhancement
      A. Mahanty  14/04/2005 115.6   3491357 BRA Enhancement
                                             Balance Value retrieval modified.
      J.N. Louw   05/04/2005 115.5   4032647
      R.V. Pahune 05/04/2005 115.4   4276047
      J.N. Louw   31/01/2005 115.3   4153654
      J.N. Louw   12/01/2005 115.2   4117011
      J.N. Louw   07/01/2005 115.1   4106307
                                     4106240
      J.N. Louw   22/12/2004 115.0           Next Version of Main ZA Tax
                                             Package.
                                             For detail history see
                                             py_za_tx_01032004
*/

-------------------------------------------------------------------------------
--                               PACKAGE BODY                                --
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
-- WrtHrTrc
-- Wrapper for py_za_tx_utl_01032005.WriteHrTrace
-------------------------------------------------------------------------------
PROCEDURE WrtHrTrc(
   p_Buf IN VARCHAR2
   )
AS

BEGIN
   py_za_tx_utl_01032005.WriteHrTrace(p_Buf);

Line: 175

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

Line: 182

   SELECT last_day(dbi_SES_DTE)
     INTO nti_CurMthEndDte
     FROM dual;

Line: 573

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

Line: 603

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