APPS.CN_PMTSUB_PUB SQL Statements

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

Line: 139

   x_loading_status := 'CN_UPDATED';

Line: 223

      SELECT payrun_id, status, object_version_number
        INTO l_payrun_id, l_status, l_ovn
        FROM cn_payruns
       WHERE name = p_payrun_name
       AND org_id=l_org_id
         FOR update of payrun_id;

Line: 430

   SELECT name
     FROM cn_payruns
    WHERE payrun_id = p_payrun_id
     AND  status = 'UNPAID';