APPS.ZPB_EXTERNAL_BP_PUBLISH SQL Statements

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

Line: 75

     CURSOR c_publ_id IS SELECT analysis_cycle_id, BUSINESS_AREA_ID, owner_id
     FROM zpb_analysis_cycles a , zpb_cycle_relationships b
     WHERE a.name = p_bp_name
     AND a.analysis_cycle_id = b.published_ac_id
     and a.BUSINESS_AREA_ID in (select BUSINESS_AREA_ID
     from zPB_BUSINESS_AREAS_VL where name = p_ba_name);

Line: 84

     CURSOR c_horzstart_type IS SELECT value FROM zpb_ac_param_values
     WHERE analysis_cycle_id = l_published_id
     AND param_id =    ( SELECT tag FROM fnd_lookup_values_vl
     WHERE LOOKUP_TYPE = 'ZPB_PARAMS'      AND lookup_code = 'CAL_HS_TYPE');

Line: 89

     CURSOR c_horzend_type IS SELECT value FROM zpb_ac_param_values
     WHERE analysis_cycle_id = l_published_id
     AND param_id =    ( SELECT tag FROM fnd_lookup_values_vl
     WHERE LOOKUP_TYPE = 'ZPB_PARAMS'      AND lookup_code = 'CAL_HE_TYPE');

Line: 94

     CURSOR c_horzstart_mem IS SELECT value FROM zpb_ac_param_values
     WHERE analysis_cycle_id = l_published_id
     AND param_id =    ( SELECT tag FROM fnd_lookup_values_vl
     WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HS_TIME_MEMBER');

Line: 99

     CURSOR c_horzend_mem IS SELECT value FROM zpb_ac_param_values
     WHERE analysis_cycle_id = l_published_id
     AND param_id =    ( SELECT tag FROM fnd_lookup_values_vl
     WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HE_TIME_MEMBER');

Line: 104

     CURSOR c_bp_external IS SELECT value FROM zpb_ac_param_values
      WHERE analysis_cycle_id = l_published_id
        AND param_id =
    ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
         AND lookup_code = 'OVERRIDE_EXTERNAL_USER_CHECK');

Line: 124

select count(BUSINESS_AREA_ID) into l_count
   from zPB_BUSINESS_AREAS_VL where name = p_ba_name;

Line: 159

       SELECT COUNT(*) INTO l_user_exists FROM ZPB_BP_EXTERNAL_USERS
        WHERE analysis_cycle_id = l_published_id
          AND user_id = l_user;

Line: 207

    SELECT value into l_bp_start FROM zpb_ac_param_values
      WHERE analysis_cycle_id = l_published_id
        AND param_id =
    ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
         AND lookup_code = 'CALENDAR_START_DATE');

Line: 337

       SELECT value INTO l_start_lvl FROM zpb_ac_param_values
        WHERE analysis_cycle_id = l_published_id
          AND param_id =
       ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
           AND lookup_code = 'CAL_HS_LEVEL');

Line: 345

     zpb_acval_pvt.val_solve_hrzselections(
                          p_api_version       => 1.0,
                          p_init_msg_list     => FND_API.G_TRUE,
                          p_commit            => FND_API.G_FALSE,
                          p_validation_level  => FND_API.G_VALID_LEVEL_FULL,
                          x_return_status     => x_return_status,
                          x_msg_count         => x_msg_count ,
                          x_msg_data          => x_msg_data ,
                          p_analysis_cycle_id => l_published_id,
                          p_hrz_level         => l_start_lvl,
                          x_isvalid           => l_valid
                          );

Line: 368

       SELECT value INTO l_end_lvl FROM zpb_ac_param_values
        WHERE analysis_cycle_id = l_published_id
          AND param_id =
       ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
            AND lookup_code = 'CAL_HE_LEVEL');

Line: 376

     zpb_acval_pvt.val_solve_hrzselections(
                          p_api_version       => 1.0,
                          p_init_msg_list     => FND_API.G_TRUE,
                          p_commit            => FND_API.G_FALSE,
                          p_validation_level  => FND_API.G_VALID_LEVEL_FULL,
                          x_return_status     => x_return_status,
                          x_msg_count         => x_msg_count ,
                          x_msg_data          => x_msg_data ,
                          p_analysis_cycle_id => l_published_id,
                          p_hrz_level         => l_end_lvl,
                          x_isvalid           => l_valid
                          );

Line: 417

            ,PUBLISH_OPTIONS_IN    => 'UPDATE_FOR_FUTURE'
            ,p_bp_name_in          => p_bp_name
            ,p_external            => 'Y'
            ,p_START_MEM_IN        => l_start_id
            ,p_END_MEM_IN          => l_end_id
            ,p_send_date_in        => p_send_date
            ,PUBLISHED_AC_ID_OUT   => l_published_id
            ,X_item_key_out        => X_item_key
            );