APPS.PY_ZA_TX_01082000 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: 615

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

Line: 651

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

Line: 686

      SELECT min(ptp.start_date)
        INTO l_StrtDte
        FROM per_time_periods ptp
       WHERE ptp.prd_information1 = trc_AsgTxYear
         AND ptp.payroll_id = con_PRL_ID;

Line: 695

      SELECT max(ptp.end_date)
        INTO l_EndDate
        FROM per_time_periods ptp
       WHERE ptp.prd_information1 = trc_AsgTxYear
         AND ptp.payroll_id = con_PRL_ID;

Line: 706

      SELECT MAX(ptp.end_date) "EndDate"
        INTO l_EndDate
        FROM per_time_periods ptp
       WHERE ptp.payroll_id = con_PRL_ID
         AND ptp.prd_information1 = trc_AsgTxYear
       GROUP BY ptp.prd_information1;

Line: 876

     SELECT MAX(ptp.end_date) "EndDate"
       INTO l_EndDate
       FROM per_time_periods ptp
      WHERE ptp.payroll_id = con_PRL_ID
        AND ptp.prd_information1 = trc_AsgTxYear
      GROUP BY ptp.prd_information1;