APPS.CZ_IB_LOCKING dependencies on CZ_CONFIG_DETAILS_V

Line 30: -- check CZ_CONFIG_DETAILS_V

26: END LOOP;
27:
28: ELSE
29: -- if p_config_session_item_id is specified then
30: -- check CZ_CONFIG_DETAILS_V
31: FOR i IN(SELECT 'x' FROM CZ_CONFIG_DETAILS_V
32: WHERE config_hdr_id=p_config_session_hdr_id AND
33: config_rev_nbr=p_config_session_rev_nbr AND
34: config_item_id=p_config_session_item_id AND

Line 31: FOR i IN(SELECT 'x' FROM CZ_CONFIG_DETAILS_V

27:
28: ELSE
29: -- if p_config_session_item_id is specified then
30: -- check CZ_CONFIG_DETAILS_V
31: FOR i IN(SELECT 'x' FROM CZ_CONFIG_DETAILS_V
32: WHERE config_hdr_id=p_config_session_hdr_id AND
33: config_rev_nbr=p_config_session_rev_nbr AND
34: config_item_id=p_config_session_item_id AND
35: component_instance_type='I' AND

Line 175: ' FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V ' ||

171: ' l_config_tbl csi_cz_int.config_tbl; ' ||
172: ' l_rec_counter NUMBER := 0; ' ||
173: ' l_ndebug NUMBER := 0; ' ||
174: ' BEGIN ' ||
175: ' FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V ' ||
176: ' WHERE config_hdr_id=:1 AND ' ||
177: ' config_rev_nbr=:2 AND ' ||
178: ' config_item_id=NVL(:3, config_item_id) AND ' ||
179: ' component_instance_type=''I'' AND ' ||

Line 381: ' FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V ' ||

377: ' l_config_tbl csi_cz_int.config_tbl; ' ||
378: ' l_rec_counter NUMBER := 0; ' ||
379: ' l_ndebug NUMBER := 1; ' ||
380: ' BEGIN ' ||
381: ' FOR i IN(SELECT instance_hdr_id,instance_rev_nbr, config_item_id FROM CZ_CONFIG_DETAILS_V ' ||
382: ' WHERE config_hdr_id=:1 AND ' ||
383: ' config_rev_nbr=:2 AND ' ||
384: ' config_item_id=NVL(:3, config_item_id) AND ' ||
385: ' component_instance_type=''I'' AND ' ||