APPS.HXC_PROJ_PAY_DEP_VALIDATION SQL Statements

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

Line: 88

         SELECT 1
           INTO l_count
           FROM hxc_pay_pa_link_all
          WHERE timecard_id = p_timecard_id
            AND rownum < 2 ;

Line: 109

       SELECT retrieval_process_id
         INTO l_retrieval_process_id
         FROM hxc_retrieval_processes
        WHERE name = 'BEE Retrieval Process';

Line: 136

        'SELECT 1
           FROM hxc_transactions ht,
                hxc_transaction_details htd
          WHERE ht.transaction_process_id in ('||l_retrieval_process_id||', -1 )
            AND ht.transaction_id = htd.transaction_id
            AND ht.type    = ''RETRIEVAL''
            AND ht.status  = ''SUCCESS''
            AND htd.status = ''SUCCESS''
            AND htd.time_building_block_id IN ('|| l_active_building_block_ids ||')
            AND rownum > 2';

Line: 187

           SELECT 1
             INTO l_count
             FROM hxc_pay_pa_link_all
            WHERE timecard_id = p_timecard_id
              AND rownum < 2 ;