APPS.CZ_IB_LOCKING SQL Statements

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

Line: 19

    FOR i IN(SELECT 'x' FROM CZ_CONFIG_HDRS
              WHERE config_hdr_id=p_config_session_hdr_id AND
                    config_rev_nbr=p_config_session_rev_nbr AND
                    component_instance_type='R' AND
                    deleted_flag='0')
    LOOP
      RETURN TRUE;

Line: 31

    FOR i IN(SELECT 'x' FROM CZ_CONFIG_DETAILS_V
              WHERE config_hdr_id=p_config_session_hdr_id AND
                    config_rev_nbr=p_config_session_rev_nbr AND
                    config_item_id=p_config_session_item_id AND
                    component_instance_type='I' AND
                    ib_trackable='1')
    LOOP
      RETURN TRUE;

Line: 175

 '   FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V  ' ||
 '            WHERE config_hdr_id=:1 AND ' ||
 '                  config_rev_nbr=:2 AND ' ||
 '                  config_item_id=NVL(:3, config_item_id) AND ' ||
 '                  component_instance_type=''I'' AND ' ||
 '                  ib_trackable=''1'') ' ||
 '   LOOP ' ||
 '     l_rec_counter := l_rec_counter + 1; ' ||

Line: 381

'    FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V ' ||
'             WHERE config_hdr_id=:1 AND ' ||
'                   config_rev_nbr=:2 AND ' ||
'                   config_item_id=NVL(:3, config_item_id) AND ' ||
'                   component_instance_type=''I'' AND ' ||
'                   ib_trackable=''1'') ' ||
'    LOOP ' ||
'      l_rec_counter := l_rec_counter + 1; ' ||