APPS.IGC_CC_APPROVAL_PROCESS SQL Statements

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

Line: 151

  SELECT UPPER(icrc.cc_can_prpr_apprv_flag)
    FROM   IGC_CC_ROUTING_CTRLS icrc
   WHERE  icrc.org_id   = p_org_id
        AND    icrc.cc_state = p_cc_state
        AND    icrc.cc_type  = p_cc_type;

Line: 158

   SELECT meaning
     FROM fnd_lookups
    WHERE lookup_code     = p_cc_state
          AND lookup_type = 'IGC_CC_STATE';

Line: 164

   SELECT meaning
     FROM fnd_lookups
    WHERE lookup_code     = p_cc_type
          AND lookup_type = 'IGC_CC_TYPE';

Line: 170

   SELECT name
     FROM hr_organization_units
    WHERE organization_id = p_org_id;

Line: 453

       SELECT cc_encmbrnc_status
         INTO l_cc_encumb_status
         FROM igc_cc_headers
        WHERE cc_header_id = l_cc_header_id;

Line: 617

    SELECT cc_num
     FROM igc_cc_headers
     WHERE cc_header_id = l_cc_header_id;

Line: 644

    UPDATE IGC_CC_HEADERS
       SET cc_apprvl_status = 'AP'
     WHERE cc_header_id = l_cc_header_id;

Line: 702

  IGC_CC_ACTIONS_PKG.Insert_Row
   ( p_api_version               => 1.0
   , p_init_msg_list             => FND_API.G_FALSE
   , p_commit                    => FND_API.G_FALSE
   , p_validation_level          => FND_API.G_VALID_LEVEL_FULL
   , x_return_status             => l_return_status
   , x_msg_count                 => l_msg_count
   , x_msg_data                  => l_msg_data
   , P_Rowid			 => l_rowid
   , P_CC_Header_Id              => p_cc_header_id
   , P_CC_Action_Version_Num     => p_cc_version_num
   , P_CC_Action_Type            => 'AP'
   , P_CC_Action_State           => l_cc_state
   , P_CC_Action_Ctrl_Status     => p_cc_ctrl_status
   , P_CC_Action_Apprvl_Status   => p_cc_apprvl_status
   , P_CC_Action_Notes           => p_cc_notes
   , P_Last_Update_Date          => sysdate
   , P_Last_Updated_By           => fnd_global.user_id
   , P_Last_Update_Login         => fnd_global.login_id
   , P_Creation_Date             => sysdate
   , P_Created_By                => fnd_global.user_id
   ) ;