APPS.CSI_ITEM_INSTANCE_PUB dependencies on CZ_CONFIG_ITEMS_V

Line 819: FROM cz_config_items_v

815: ,config_rev_nbr
816: INTO l_component_ins_type
817: ,l_config_hdr_id
818: ,l_config_rev_nbr
819: FROM cz_config_items_v
820: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
821: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
822: AND config_item_id = p_instance_rec.config_inst_item_id;
823: EXCEPTION

Line 2778: FROM cz_config_items_v

2774: ,config_rev_nbr
2775: INTO l_component_ins_type
2776: ,l_config_hdr_id
2777: ,l_config_rev_nbr
2778: FROM cz_config_items_v
2779: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
2780: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
2781: AND config_item_id = p_instance_rec.config_inst_item_id;
2782: EXCEPTION

Line 3815: FROM cz_config_items_v

3811: ,config_rev_nbr
3812: INTO l_component_ins_type
3813: ,l_config_hdr_id
3814: ,l_config_rev_nbr
3815: FROM cz_config_items_v
3816: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
3817: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
3818: AND config_item_id = p_instance_rec.config_inst_item_id;
3819: EXCEPTION